Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “commenter” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
commenter15141068(None) 
commencer17147801commencer
commender16167921commender
commented16129601commented
commenters16139471commenters
cementer1239192c_ementer
commander16127402commander
commence16149102commence_
commenced18157132commenced
commencers18156372commencers
commences17139572commences
commended17137012commended
commenders17137142commenders
comment1310317702comment__
commentary1945752commentary
comments142913872comment_s
commoner142710632common_er
communer14349292commun_er
commuter143010132comm_uter
concenter13312212concenter
consenter11312492consenter
fomenter1339262fo_menter
tormenter1146702tormenter
ammeter1148393_amme_ter
augmenter1254123augmenter
carpenter1346493carpenter
cemented1338373c_emented
cementers1338303c_ementers
center84421413c___enter
coelentera1243643coelentera
cointer93616723co__inter
combater1439373co_mbater
combiner14259723combin_er
comelier12310653co_melier
comember1644163co_member
comether1537253co_mether
comforter16255983comforter
commanded17136503commanded
commandeer17124113commandeer
commanders17146683commanders
commandery20134253commandery
commend144010183commen__d
commendam1544953commendam
commends15308463commen_ds
commensal1546013commensal
commentate16108173commentate
commentated1886213commentated
commentates17107603commentates
commentator1755273commentator
commenting1749153commenting
commerce16116323commerce_
commerced18125463commerced
commerces17147233commerces
comminute1596143comminute_
comminuted17224573comminuted
comminutes1685613comminutes
committed1645713committed
committee1546233committee
commoners15339783common_ers
commune13329353commun_e_
communed15338203commun_ed
communers15338403commun_ers
communes143411233commun_es
commute134310423comm_ute_
commuted15288963comm_uted
commuters15378883comm_uters
commutes143011873comm_utes
compacter17257883compacter
compeer133811553compe__er
compeller1546293compeller
compete134716553compe_te_
competed154113593compe_ted
competes144117243compe_tes
completer153310413completer
composter15369563composter
computer144511503co_mputer
concenters14410583concenters
condenser1287413condenser
congener112412193congen_er
connecter1349053connecter
consented12311943consented
consenters12410843consenters
contender1239563contender
contented12313043contented
contester11311183contester
convener132913163conven_er
convented15410753convented
converter14311013converter
correcter1348103correcter
counter94220143co__unter
coveter122912063co_ve_ter
cozener18328953co_zen_er
documenter1553283documenter
fermenter1497543fermenter
fomented1437803fo_mented
fomenters1437853fo_menters
immenser1244173_immenser
lamenter1038863_lamenter
ohmmeter1543613ohmme_ter
orienter838313_orienter
recommender1852723recommender
sommelier1343643sommelier
tormented1245963tormented
tormenters1245823tormenters
tormentor1144363tormentor

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.1731032896.0
2DLD Change Limit1486411058.82616841.3
3Display Results1051050.0462282.6
 (SQL Overall)1786911059.04519755.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.