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

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

112 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
resettlements155321(None) 
resettlement1453531resettlement_
presettlement1772242presettlement_
settlements1345542__settlements
unsettlements1562742unsettlements
belittlements1772063belittlements
resentments1346543resent__ments
restatements1455283res_tatements
settlement1246473__settlement_
unsettlement1462883unsettlement_
battlements1544964__battlements
belittlement1682494belittlement_
besetments1445294bese_t__ments
curettements1652484curett_ements
embattlements1952784embattlements
entitlements1455104_entitlements
presentiments1753024present_iments
presentments1654304present__ments
resentment1248084resent__ment_
resettles936564resettl__e__s
ressentiments1582844ressent_iments
restatement1356264res_tatement_
retirements1357614r__etirements
revealments1644494reve_al_ments
revelments1546864reve__l_ments
revetments1546434reve_t__ments
revilements1647134r__evilements
battements1455815__batt_ements
battlement1446095__battlement_
bedazzlements2681335bedazzlements
bedevilments2052475bedevil_ments
befuddlements2261205befuddlements
beguilements17113895be_guilements
bereavements19154205bere_avements
besetment1346955bese_t__ment_
betterments1544715__betterments
curettement1552815curett_ement_
debatements1656045de_bat_ements
defilements1747075__defilements
denotements1446865de_not_ements
despisements1785165des_pisements
despoilments1753405despoil_ments
devotements1745615de_vot_ements
disablements1754915dis_ablements
dismantlements19103025dismantlements
ejectments2144055_eject__ments
elements10312175___e__lements
embattlement1853075embattlement_
embezzlements2762005embezzlements
emblements1647795___emblements
embrittlements2061605embrittlements
enfeeblements2062215enfeeblements
ennoblements1654125_ennoblements
enticements1598165_e_nticements
entitlement1355815_entitlement_
escapements1744825_es_capements
excitements2254285_excit_ements
extolments1944405_e_xtol_ments
forestallments1961185fores_tallments
installments1453275ins_tallments
instalments1354415ins_tal_ments
instillments1453195ins_tillments
inveiglements1962415inveiglements
misstatements17122905misstatements
preretirement1762715preretirement_
presentiment1654455present_iment_
presentment1555675present__ment_
presettles1245025presettl__e__s
rabblements1753645r__abblements
radioelements1663085radioelements
ravelments1545195rave__l_ments
reattachments2062085reattachments
reattempts1451505re_att_em_pts
recements13312285r__e__cements
reconcilements2062395reconcilements
recrements1449355r__e_crements
redeployments2162205redeployments
redevelopments22172735redevelopments
reemployments22122465re_employments
reenactments1653185re_enactments
reengagements1752745reengagements
reequipments2551985re_equipments
refinements1646795r__efinements
reinstatements1661915reinstatements
remeasurements18141485remeasurements
remitments1446845re_mit__ments
renouncements17163905renouncements
repellents1245145repe__l_lents
replacements1854445re_placements
requirements2384045re_quirements
rescindments1752795res_cindments
reselects1156415rese__l__ects
resetters9129465resett___e_rs
resettle837305resettl__e___
resettled1035305resettl__e__d
resettling1135895resettl__in_g
resolvents1344345res__ol_vents
ressentiment1473365ressent_iment_
retirement1259125r__etirement_
revealment1545545reve_al_ment_
revelment1448775reve__l_ment_
revetment1448325reve_t__ment_
revilement1548485r__evilement_
securements1545495__securements
seducements1654495__seducements
sentiments1248275__sent_iments
startlements1453395_startlements
statements1256885__s_tatements
supplements1754595__supplements
testaments1265355tes__t_aments
unsettledness1462445unsettledness
vestments1486815ves__t__ments

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 Filter1786911247900.423422437.4
2DLD Change Limit1247901128.79614187.1
3Display Results1121120.0761473.7
 (SQL Overall)1786911129.29519224.4
 
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.