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

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

77 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
misstatements1712290(None) 
misstatement16113361misstatement_
misplacements2162593misplacements
reinstatements1661913reinstatements
restatements1455283_restatements
statements1256883___statements
assuagements1552974_assuagements
displacements2053894displacements
installments1453274_installments
instalments1354414_insta_lments
mismanagements1862274mismanagements
misplacement2053164misplacement_
misstates11710634misstat__e__s
mistreatments1762774mistreat_ments
overstatements1962494overstatements
reinstatement1562274reinstatement_
restatement1356264_restatement_
statement1148794___statement_
abatements1446355___abatements
assortments1354005_assort_ments
assuagement1463495_assuagement_
battements1455815__bat_tements
chastisements2061675chastisements
curettements1652485curet_tements
debatements1656045__debatements
disablements1754915di_sablements
disagreements1763655disagreements
disbandments1853445di_sbandments
disbarments1654935di_sba_rments
disbursements1853915disbursements
disengagements19163425disengagements
disguisements1763935disguisements
disheartenments21242645disheartenments
disinterments1664865di_sinterments
dislodgements18103455dislodgements
dismantlements19103025dismantlements
disparagements2063485disparagements
displacement1954425displacement_
disportments1755355disport_ments
dissentients1354225dissent_ients
dissepiments1753465diss_epiments
disseverments19123185disseverments
enslavements1754125_enslavements
escapements1744825__escapements
impalements1746435_i_mpalements
incitements1556295_i_ncitements
installment1353725_installment_
instalment1245385_insta_lment_
instillments1453195_instillments
instruments1354685_inst_ruments
managements1655315m__anagements
measurements1653195meas_urements
microelements1963855microelements
misagents1246795mi_s_a__gents
misalignments1862175misalignments
misevents1456005mi_s___events
misjudgments25151985mi_sjudgments
mismanagement1762585mismanagement_
misrepresents17142205misrepresents
missilemen1453195miss_ilemen__
misstamps1543375missta__m__ps
misstarts1145835missta____rts
misstate10711345misstat__e___
misstated1278975misstat__e__d
misstating13129315misstat__in_g
missteers1135915miss__te_e_rs
mistreatment1653445mistreat_ment_
overstatement1863005overstatement_
pistareens1243155pi_stare_en_s
resettlements1553215resettlements
ressentiments1582845ressentiments
settlements1345545__settlements
solacements1554385__solacements
startlements1453395___startlements
testaments1265355_testa__ments
understatements1881675understatements
unsettlements1562745unsettlements

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 Filter1786911247900.390458182.1
2DLD Change Limit124790778.40614845.3
3Display Results77770.0631222.2
 (SQL Overall)178691778.85920170.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.