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

101 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
incrusts103625(None) 
encrusts1045281encrusts
incrust949201incrust_
intrusts837721intrusts
becrusts1244842becrusts
crusts84916542__crusts
encrust947872encrust_
entrusts847112entrusts
inbursts1044322inbursts
incests92711382inc_ests
incross937662incros_s
incrusted12125842incrusted
incuses93514852inc_uses
intrust7311492intrust_
piecrusts1342602piecrusts
anacruses1145533anacruses
anacrusis1143893anacrusis
anchusas1344763anchusas
ancress978613ancres_s
antirusts948143antirusts
becrust1137983becrust_
crests85218703__crests
cruets85314953__cruets
cruses88127713__cruses
crusets93811043__crusets
crust75827663__crust_
crusty114911343__crusty
distrusts1046523distrusts
encrusted12125003encrusted
encrypts1542983encrypts
encysts1244313enc_ysts
entrust7410883entrust_
ictuses938303i_ctuses
imprests1246313imprests
inburst937163inburst_
incants92012803inc_ants
incases93615973inc_ases
incenses102411003incenses
incents92414533inc_ents
incepts11238283inc_epts
incest82918743inc_est_
incipits1246263incipits
incises93414893inc_ises
inclasps1244353inclasps
incloses101610533incloses
includes1146023includes
incorpses1345173incorpses
increases1157383increases
increate10312203increate
incrosses1146033incrosses
incrusting13126473incrusting
incubus1144743inc_ubus
incubuses1343533incubuses
incudes10319523inc_udes
incult82414773inc_ult_
incurs83012283inc_u_rs
incurves1336393incurves
incus73315053inc_u__s
incuse83513573inc_us_e
incused102911173inc_used
indrafts1295583indrafts
inducts10259573in_ducts
indults8289493in_dults
inerts64517023iner__ts
infests10279793in_fests
infracts1346623infracts
infuses102711873in_fuses
ingests83210983in_gests
ingrafts12105803ingrafts
ingress838653ingres_s
inputs837703in_pu_ts
inquests1744943inquests
inruns6359513in_ru_ns
inrush936513in_rus_h
inrushes1136273in_rushes
insists739083in_sists
instructs1145793instructs
insults7268963in_sults
interests9312553interests
intrants8312863intrants
intreats8311543intreats
introits859713introits
intrudes937493intrudes
intrusted1076903intrusted
intuits7310313in_tuits
intwists1145593intwists
invests10319683in_vests
irrupts943733i_rrupts
locusts9277933loc_usts
mistrusts1146013mistrusts
piecrust1244633piecrust_
recruits1036563recruits
rusts55026993___rusts
sacrists1039563sacrists
thrusts10226523_thrusts
trusts64714433__trusts
uncross938193uncros_s
unitrusts943323unitrusts
unrests7229463un_rests
untruss736553untrus_s
untrusty1144223untrusty

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621017.18620339.8
3Display Results1011010.0462195.7
 (SQL Overall)1786911017.63823395.0
 
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.