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 “consisted” 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
consisted123850(None) 
coassisted1343292coassisted
coexisted1944142coexisted
congested1338672congested
consented12311942consented
consigned1346322consigned
consist9316032consist__
consistent1248552consistent
consists10310592consist_s
consorted1239772consorted
consulted1277922consulted
contested12310692contested
convicted1746312convicted
insisted998672_insisted
assisted936233_assisted
canistel10187253can_istel
canister101710853can_ister
cannister1155723cannister
censused11184973census_ed
cisted95217523c___isted
coasted104015953co__asted
coedited1237833coedi_ted
coesite9713623coesi_te_
coesites101313093coesi_tes
cognised1256313cognis_ed
cohosted1436133co_hosted
combusted1644643combusted
committed1645723committed
composted16378813composted
conceited14310423conceited
concerted14312113concerted
concise11314473concis_e_
conciser12310243concis_er
concocted1346763concocted
concreted1439413concreted
concussed1444753concussed
conducted1547313conducted
confected1739073confected
confessed1546053confessed
confided1537453confi_ded
confined14310403confi_ned
confirmed1745563confirmed
confiscated1953373confiscated
conflated1539333conflated
conflicted1844053conflicted
confused1437033confus_ed
confuted1437683con_futed
connected1438753connected
connived1436433conni_ved
connoted1138863con_noted
conscripted1853433conscripted
consenter11312493consenter
conserved1538853conserved
consider11310393consi_der
considered1444283considered
consignee1246563consignee
consigner1246633consigner
consistence1555673consistence
consistency1853973consistency
consisting1349523consisting
consistory1545573consistory
consociated1645213consociated
consoled112911453cons_oled
conspired1445663conspired
constipated1645463constipated
constituted1475053constituted
constricted1646363constricted
construed1247313construed
consulter1198223consulter
consumed1337923cons_umed
contacted14139093contacted
contented12313043contented
contester11311183contester
continued1248483continued
contorted1239473contorted
contrasted1348573contrasted
contused1138443contus_ed
convected1738783convected
convented15410753convented
converted15311563converted
convinced1745363convinced
corseted11311473cors_eted
cosied94819883co_si__ed
cosigned1235723co_signed
cosseted1178343co_sseted
costed95623113co___sted
desisted1039783_desisted
enlisted978193_enlisted
foisted113210603fo__isted
hoisted113411293ho__isted
insister888783_insister
ionised82911493ion_is_ed
ironfisted1442163ironfisted
joisted15379173jo__isted
monished1438133mon_ished
nonsuited1046573nonsuited
nonsystem1452633nonsystem
nonvested1346003nonvested
persisted1247143persisted
posited10511493po_si_ted
resisted9312693_resisted
subsisted1245783subsisted
touristed1044303touristed
unlisted9311153_unlisted
unsifted12128773_unsifted

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.423422437.4
2DLD Change Limit1486411057.04621095.8
3Display Results1051050.0601750.0
 (SQL Overall)1786911057.52923733.7
 
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.