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

92 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
dustbins114459(None) 
dustbin1044541dustbin_
destains9311812destains
distains9413602distains
dubbins12358802du_bbins
dusting93618992dust_ing
dustings10419032dust_ings
dustpans1143232dustpans
sustains838552sustains
abstains1047323abstains
busbies113011693bus_bies
buskins133310943bus_kins
bustics11810883bust_ics
busting104221793bust_ing
bustline10208843bustline
bustlines11207353bustlines
bustling112110063bustling
curtains10259703curtains
cutins83919983cu_t_ins
cysteins1355733cysteins
dentins83419223dent_ins
destain8412083destain_
destine83719953dest_ine
destines93619663dest_ines
destiny113111463dest_iny
detains83716093d_etains
dextrins16117823dextrins
disdains1037913disdains
disjoins1647623disjoins
distain8313783distain_
distils83015803dist_ils
distrains10411333distrains
dobbins12379533d_obbins
dubbin11329263du_bbin_
dubbing133311213du_bbing
dubbings14245473du_bbings
duckpins1743693duckpins
ducting113713593duct_ing
ductings12346673duct_ings
dueting93814393duet_ing
duetting1047183duetting
dumbing13319853du_mbing
dunlins849553du_nlins
dunting93418383dunt_ing
dusking133912053dus_king
dusters84918363dust_ers
dustier83814133dust_ier
dustiest93015073dust_iest
dustily113211523dust_ily
dustiness102211033dust_iness
dustless9328353dustless
dustlike1335363dustlike
dustman1044683dustman_
dustmen1035773dustmen_
dustoffs1543163dustoffs
dustpan1043243dustpan_
dustrags1044943dustrags
dusts65923563dust___s
dustups1033913dust_ups
duties74921903du_t_ies
estrins7315853_estrins
fusains1038363fus_ains
fustians1146403fustians
fustics1279593fust_ics
gastrins9310123gastrins
gusting93917163gust_ing
hustings12378683hust_ings
hustling12228793hustling
justing153615163just_ing
justling16207253justling
lusting83619323lust_ing
lustring9269723lustring
lustrings10245553lustrings
luteins7310103lu_teins
muntins92715133munt_ins
muslins9312213mus_lins
musting103221073must_ing
nubbins11268023nu_bbins
oestrins8312673oestrins
ousting84021353oust_ing
outbids1098913ou_tbids
outsins73417863ou_tsins
postins93721203post_ins
pushpins1543343pushpins
rustics9810733rust_ics
rusting83821263rust_ing
rustling9249983rustling
rutins63818393ru_t_ins
sabins85521983__sabins
stains64923653__stains
steins64818343__steins
sustain738773sustain_

Search took 7 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.1731032896.0
2DLD Change Limit146162926.61022112.3
3Display Results92920.0462000.0
 (SQL Overall)178691926.82926166.5
 
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.