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 “compelled” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 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
compelled164613(None) 
compeller1546291compeller
compeered1646302compeered
compellers1645192compellers
compered153414922compe_red
competed154113592compe_ted
compiled1537812comp_iled
completed162810262completed
complexed23295972complexed
complied1539672comp_lied
corbelled1446612corbelled
cordelled1346402cordelled
cupelled1365742c_upelled
impelled1336072_impelled
pommelled1643082pommelled
bowelled1446173bo_welled
cancelled1456743cancelled
celled94420323c___elled
chiselled1544213chiselled
comelier12310653com_elier
comingled1543203comingled
commenced18157133commenced
commended17137013commended
commented16129603commented
commerced18125463commerced
compacted18297363compacted
companied1648023companied
compared153811823comp_ared
comparted16338423comparted
compassed1645543compassed
comped135919873comp___ed
compeer133811553compe__er
compel124412893compe_l__
compelling1746553compelling
compels133210883compe_l_s
compend144010303compe__nd
compere134616623compe_re_
comperes143217973compe_res
compete134716553compe_te_
competes144117243compe_tes
compile13312443comp_ile_
compiler1438373comp_iler
compiles14311983comp_iles
complected19295863complected
complete143412053complete_
completer153310413completer
completes153212923completes
complex2037243comp__lex
complexer22316203complexer
complexes22308093complexes
complier14310253comp_lier
complies14314523comp_lies
comported16319533comported
composed154612063comp_osed
composted16378813composted
compressed1745843compressed
comprised1648053comprised
comprized2567223comprized
compted143813523comp__ted
computed154110943comp_uted
concealed1458123concealed
congealed1346583congealed
coopered133310933coope_red
coppered153410543coppe_red
corbeled1338373corbe_led
cordelle1148433cordelle_
cordelles1248223cordelles
corralled1245283corralled
counselled1344523counselled
coupled124312673coup__led
crenelled1245403crenelled
cudgelled1443113cudgelled
cupeled1257793c_upe_led
cupeller1256103c_upeller
dispelled13117563dispelled
dowelled1356343do_welled
expelled1895863_expelled
gospeller1263743gospeller
hostelled1345703hostelled
houselled1346193houselled
hovelled15146843ho_velled
impeller1236083_impeller
lapelled11227083_lapelled
melled95023023__m_elled
modelled1236423mo_delled
morselled1245953morselled
pommeled1543103pomme_led
propelled1456903propelled
pummelled1643073pummelled
rappelled1443703rappelled
repelled113111573_repelled
respelled1257023respelled
rowelled1236633ro_welled
smelled103511853_sm_elled
spelled103714733__spelled
towelled1236353to_welled
umbelled1336273_umbelled
yodelled1334593yo_delled

Search took 9 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.1561145455.1
2DLD Change Limit148641987.95318689.9
3Display Results98980.0462130.4
 (SQL Overall)178691988.15521911.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.