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

85 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
cutbank154553(None) 
cutback1747091cutback
cutbanks1644311cutbanks
cutbacks1845812cutbacks
outback15310652outback
outbark1339452outbark
outrank112611972outrank
bank105835753___bank
bethank1666273bethank
bugbane1255863bugbane
butane8313653but_ane
buyback2045533buyback
cabana103913563c_abana
catjang1733923catjang
catwalk1645323catwalk
cetane8315283cet_ane
clank114719523c__lank
claybank1942893claybank
corban10314693corban_
corbans11313173corbans
cotan71521783cot_an_
cotans81317923cot_ans
cowbane1437673cowbane
crank114819613c__rank
cryobank1942583cryobank
cubage1178273cu_bage
cubing114213953cu_bing
curbing123814023curbing
curran8312023curran_
currans9310613currans
currant9314173currant
cutin75022783cut_in_
cutins83919983cut_ins
cutlas8313103cutla_s
cutlass938013cutlass
cutline92914543cutline
cuttage10318343cuttage
cutting103817493cutting
cutwork16176823cutwork
databank1542643databank
embank14346553_embank
fatback1836923fatback
futhark1744233futhark
hatband1346823hatband
husband1345653husband
multibank1744283multibank
mutant8317693mut_ant
nonbank1345903nonbank
nutant6316383nut_ant
outask1039103out_ask
outbacks1638983outbacks
outbake13310773outbake
outbarks1437833outbarks
outbawl1237473outbawl
outbulk1336003outbulk
outdrank1345433outdrank
outflank1544593outflank
outland81212343outland
outman83115033outman_
outmans92413283outmans
outran63218893outran_
outrang83813953outrang
outranks12298823outranks
outsang83411273outsang
outtalk1138233outtalk
outtask1137053outtask
outthank1544353outthank
outwalk1437623outwalk
runback1556603runback
rurban849043rurban_
scatback1875033scatback
setback1567143setback
stank95823303_st_ank
subtask1335713subtask
sunback1548153sunback
tank85134023__t_ank
thank125817803__thank
trank96222423__trank
turban8310483turban_
turbans939563turbans
unban72114333_unban_
unbans81912623_unbans
urban72013863_urban_
urbane82211383_urbane
wetback1875613wetback

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.813219792.1
2DLD Change Limit134027857.87317023.6
3Display Results85850.0631349.2
 (SQL Overall)178691858.74920424.2
 
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.