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

64 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
dishpan1310552(None) 
dishpans14115831dishpans
dishrag1246272dishrag
dustpan1043242dustpan
ashcan1135843_ashcan
ashman1148383_ashman
bushman1455693bushman
darshan1167063darsh_an
dasheen1136393dasheen
dashpot1346123dashpot
deadpan11225233deadpan
deskman1444323deskman
desman9311693des_man
dioxan1465773di_oxan
dipnoan1044653dipnoan
dirham12378273dirh_am
disband1138243dis_band
disbar938513dis_bar
discant103017253dis_cant
discern1038493discern
disdain938513disdain
dish86328333dish___
dished114318713dish_ed
dishelm1335833dishelm
dishes104622653dish_es
dishful1455433dishful
dishier113613403dishier
dishing124017103dishing
dishrags1346203dishrags
dishware1545433dishware
dishy125712353dish__y
disjoin1547643disjoin
dislimn1056103dislimn
dismal92412243dis_mal
dismay12229473dis_may
disown1036953dis_own
dispart101115283dis_part
dispel9310323dis_pel
dispend11289413dis_pend
displant11412223displant
display1336663display
disseat83816923disseat
distain8313783distain
distal73615773dis_tal
distant83519953dis_tant
distrain9412243distrain
divan96114843di__van
diwan95712553di__wan
dustman1044683dustman
dustpans1143233dustpans
firepan1236983firepan
fishpond1773223fishpond
fishway1943813fishway
inspan837513_inspan
kishka1232963kishka_
kishkas1343483kishkas
mishap1338863mish_ap
mishaps1438713mishaps
mishear1238393mishear
mispen10312173mis_pen
misplan1147773misplan
pushpin1443233pushpin
span65234663__s_pan
wisha114910853wish_a_

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027647.31318327.2
3Display Results64640.0164000.0
 (SQL Overall)178691647.48523873.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.