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 “comparted” 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.

121 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
comparted1633842(None) 
compacted18297361compacted
compared153811821compar_ed
comported16319531comported
combated1539822comba_ted
combatted1644652combatted
comforted17315962comforted
compacter17257882compacter
companied1648022companied
compare135814992compar_e_
comparer143611362compar_er
compares143816432compar_es
compart134016002compart__
comparts144210832compart_s
compassed1645542compassed
compered153414922comper_ed
competed154113592comp_eted
completed162810262completed
composted16378812composted
compted143813522comp__ted
computed154110952comp_uted
imparted13248062_imparted
ramparted1443542ramparted
biparted1335133_biparted
bogarted1235053bo_garted
bombarded17123633bombarded
carted98631443c___arted
charted135116853c__harted
coacted123611613co__acted
coadapted1543163coadapted
coapted123911503co__apted
coasted104015953co__asted
coated94927043co__a_ted
coempted1535333coemp__ted
coenacted1445803coenacted
coexerted1944763coexerted
collared113211143collar_ed
collated113615063colla_ted
comate104124843com_a_te_
comates114123643com_a_tes
combater1439383comba_ter
combusted1644643combusted
comforter16255983comforter
commanded17136503commanded
commented16129613commented
commerced18125463commerced
committed1645723committed
commuted15288983com_muted
compact153712213compact__
compacters18247023compacters
compactest1845043compactest
compactly2043823compactly
compactor17256023compactor
compacts16368903compact_s
compadre15295883compadre_
compadres16266413compadres
companies15311803companies
comparator1665803comparator
comparers15319393comparers
comparing162410583comparing
comparting17188373comparting
compartment1995083compartment
compasses1547393compasses
comped135919873comp___ed
compeered1646303compeered
compelled1646133compelled
compere134616623comper_e_
comperes143217973comper_es
compete134716553comp_ete_
competes144117243comp_etes
compiled1537813comp_iled
complained17175793complained
complected19295863complected
complete143412053complete_
completer153310413completer
completes153212923completes
complexed23295973complexed
complied1539673comp_lied
complotted1743733complotted
comport133616843comport__
comports143411983comport_s
composed154612063comp_osed
composited1756003composited
composter15369563composter
compote135616463comp_ote_
compotes144716513comp_otes
comprised1648053comprised
comprized2567223comprized
compute134513663comp_ute_
computer144511513comp_uter
computes143914553comp_utes
concerted14312113concerted
consorted1239773consorted
contacted14139093contacted
contorted1239473contorted
converted15311563converted
cooperated1567333cooperated
coopered133310933cooper_ed
coopted123710763coop__ted
coparented1544853co_parented
copartner1343563co_partner
coppered153410543copper_ed
costarred1244703costarred
courted103514923co__urted
covaried1448003co_varied
cuspated1335913cuspa_ted
departed1238823_departed
disparted1338853disparted
homeported1853513homeported
impacted15286353_impacted
imparked17264863_imparked
imparter12357543_imparter
impasted13297553_impasted
imported13308693_imported
marted94425213__m_arted
misparted1437263misparted
oompahed1642903oompa_hed
parted94228683___parted
smarted105012613_sm_arted
tomcatted1442063tomcatted
unparted11310823_unparted

Search took 8 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.1531167915.0
2DLD Change Limit1486411217.01621186.0
3Display Results1211210.0462630.4
 (SQL Overall)1786911217.21524766.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.