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

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

95 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
encrust94787(None) 
encrusts1045281encrusts
entrust7410881entrust
incrust949201incrust
becrust1137982becrust
crust75827662__crust
ecrus75113862e_crus_
encrusted12125002encrusted
encrypt1445322encrypt
encyst1136202enc_yst
entrusts847112entrusts
incrusts1036252incrusts
intrust7311492intrust
accurst1146243accurst
anchusa1244333anchusa
ancress978613ancress
antirust8411173antirust
becrusts1244843becrusts
becurst1147853becurst
centrist10314863centrist
crest74632693__crest
cruet74831843__cruet
crus65828483__crus_
cruse75726103__cruse
cruset84425093__cruset
crush106815993__crush
crusts84916543__crusts
crusty114911343__crusty
curst74931023__curst
ecru65819533e_cru__
ecus65421463e_c_us_
encase83714363enc_ase
encash11276943enc_ash
encaustic1343393encaustic
enchant12313113enchant
enchase1239453enchase
enclasp1145843enclasp
enclose999993enclose
encores9315213encores_
encrusting13125293encrusting
encrypts1542983encrypts
encysts1244313enc_ysts
endmost1056763endmost
englut738453englu_t
engluts834533engluts
engraft11118613engraft
engross837123engross
enlist6417043en_list
enrapt8313013en_rapt
enroot6615993en_root
enthuse1046963enthuse
entrant7318873entrant
entreat7315263entreat
entrusted1065943entrusted
entwist1048803entwist
enures63919713enures_
erst47436433e__r_st
eruct74022353e__ruct
erupt74220063e__rupt
estrus61912113estrus_
excuse1537423exc_use
exhaust1744243exhaust
inburst937163inburst
incest82918743inc_est
incross937663incross
incrusted12125843incrusted
incult82414773inc_ult
incurs83012283incurs_
incus73315053inc_us_
incuse83513573inc_use
inrush936513in_rush
intrusts837723intrusts
locust85312343loc_ust
nearest73415843nearest
necrose939723necrose
onrush935343on_rush
piecrust1244633piecrust
recruit939773recruit
rust45544913___rust
sacrist9315423sacrist
tenorist8413023tenorist
thrust91911893_thrust
trust55426853__trust
uncast84215713unc_ast
uncross938193uncross
uncus74014983unc_us_
uncut73219173unc_u_t
undrest8313013undrest
unitrust845563unitrust
unjust1337873un_just
unrest62918853un_rest
untruest847783untruest
untruss736553untruss
untrusty1144223untrusty
xenocryst2152023xenocryst

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 Filter1786911340270.1531167915.0
2DLD Change Limit134027958.62615537.6
3Display Results95950.0332878.8
 (SQL Overall)178691958.81220278.1
 
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.