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

129 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
encirclements1913323(None) 
encirclement18133411encirclement_
enforcements1954953enforc_ements
enticements1598163enti_c_ements
entitlements1455103enti_tlements
encasements1547454enc__asements
encipherments2262014encipherments
encircles1343924encircl__e__s
encouragements1962174encouragements
endorsements1555494endor_sements
enfeeblements2062214enfeeblements
enforcement1855684enforc_ement_
enframements1954624en_framements
engorgements1694664engor_gements
enhancements1954894enhanc_ements
enlacements1546994en_lac_ements
enlargements1555194enlar_gements
ennoblements1654124en_noblements
enrichments1855334enri_c_hments
enrollments1354964en__rollments
enrolments1246854en__rol_ments
enshrinements1853364enshrinements
ensorcellments1861274ensorcellments
entanglements1653704entanglements
enthrallments1862334enthrallments
enthronements1863794enthronements
enticement1489604enti_c_ement_
entitlement1355814enti_tlement_
environments1753234envir_onments
excitements2254284exci__tements
excrements2146984exc_r__ements
incitements1556294inci__tements
increments14410104inc_r__ements
accouchements2161985accouchements
accruements1753775_accr_uements
amercements1755265_amerc_ements
beguilements17113895begui__lements
belittlements1772065belittlements
cajolements2254165__cajolements
cerements13411455__cer__ements
circlets1235665__circl__e_ts
circumvents2053695__circumvents
complements1948185__complements
couplements1756195__couplements
decrements1549385dec_r__ements
defilements1747075defi__lements
deforcements2054665deforc_ements
denouncements18143805denounc_ements
divorcements2054415divorc_ements
effacements2154875e_ffac_ements
elements10312175e_____lements
embattlements1952785embattlements
embezzlements2762005embezzlements
emblements1647795e___mblements
embracements2055245e_mbracements
embrittlements2061605embrittlements
emplacements2054575emplac_ements
enactments1446525en__ac_tments
encampments19103935enc__ampments
encasement1448705enc__asement_
encashments1875065enc__ashments
enchainments1953485enc_hainments
enchantments1953405enc_hantments
encipherment2162685encipherment_
encircle1243945encircl__e___
encircled1443335encircl__e__d
encircling1542845encircl__in_g
encouragement1862605encouragement_
encroachments2282365encroachments
encystments1853625enc__ystments
endorsement1456305endor_sement_
enfeeblement1962345enfeeblement_
enframement1855385en_framement_
engagements1546505en__gagements
engorgement15115185engor_gement_
engraftments1852945en_graftments
engrossments1553275en_grossments
engulfments1753315en__gulfments
enhancement1855625enhanc_ement_
enjambements2552705en_jambements
enlacement1458145en_lac_ement_
enlargement1455855enlar_gement_
enlightenments2061015enlightenments
enlistments1345665enli__stments
ennoblement1554855en_noblement_
enrichment1746085enri_c_hment_
enrollment1245645en__rollment_
enrolment1148475en__rol_ment_
enserfments1654685enser__fments
enshrinement1753535enshrinement_
enslavements1754125en_slavements
ensorcellment1761335ensorcellment_
entailments1346355en_tail_ments
entanglement1554085entanglement_
enthrallment1752845enthrallment_
enthronement1754465enthronement_
entrainments1465455en_trainments
entrancements17105175entrancements
entrapments1546295en_tr_apments
entreatments14114395en_treatments
entremets1147145en_tr__eme_ts
entrustments1453805en_trustments
environment1653705envir_onment_
escapements1744825esc__apements
escarpments1753445escar__pments
excitement2154875exci__tement_
excrement2048065exc_r__ement_
implements1647855___implements
incitement1447135inci__tement_
inclement1349925___inclement_
increment13411685inc_r__ement_
indictments1654405indi_c_tments
indorsements1565185indor_sements
inducements1655535in_duc_ements
infringements1963355infringements
inurements1249145in_ur__ements
inveiglements1962415inveiglements
microelements1963855microelements
radioelements1663095radioelements
reconcilements2062395reconcilements
recrements1449355rec_r__ements
reinforcements2161975reinforc_ements
renouncements17163905renounc_ements
requirements2384045requir__ements
retirements1357615retir__ements
revilements1647135revi__lements
securements1545495secur__ements
startlements1453395_startlements
unsettlements1562745unsettlements

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.406440125.6
2DLD Change Limit1247901299.14013653.2
3Display Results1291290.0801612.5
 (SQL Overall)1786911299.62618563.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.