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

69 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
cutbanks164431(None) 
cutbacks1845811cutbacks
cutbank1545531cutbank_
cutback1747092cutback_
outbacks1638982outbacks
outbarks1437832outbarks
outranks12298822outranks
banks115527903___banks
bethanks1765313bethanks
bugbanes1345153bugbanes
butanes9312743but_anes
buybacks2144783buybacks
cabanas112413033c_abanas
catjangs1843223catjangs
catwalks1744793catwalks
cetanes9315133cet_anes
clanks124615183c__lanks
claybanks2042413claybanks
corbans11313173corban_s
cotans81317923cot_an_s
cowbanes1537423cowbanes
cranks125015313c__ranks
cryobanks2042103cryobanks
cubages1237923cu_bages
curbings13407313curbings
currans9310613curran_s
currants1037933currants
cutins83919983cut_in_s
cutlas8313103cutla__s
cutlases1038033cutlases
cutlass938013cutla_ss
cutlines102413273cutlines
cuttages11297223cuttages
cuttings11277613cuttings
cutworks17166003cutworks
databanks1642393databanks
embanks15295703_embanks
fatbacks1946003fatbacks
futharks1843783futharks
hatbands1446293hatbands
husbands1444763husbands
mutants938583mut_ants
nonbanks1445033nonbanks
outasks1138173out_asks
outback15310653outback_
outbake13310773outba_ke
outbakes1439993outbakes
outbark1339453outbark_
outbawls1336053outbawls
outbulks1444763outbulks
outflanks1643233outflanks
outlands988563outlands
outmans92413283outman_s
outrank112611973outrank_
outtalks1236503outtalks
outtasks1235633outtasks
outthanks1653153outthanks
outwalks1535993outwalks
runbacks1655903runbacks
scatbacks1974713scatbacks
setbacks1686303setbacks
stanks104917703_st_anks
subtasks1444493subtasks
tanks94624733__t_anks
thanks134313133__thanks
tranks104017763__tranks
turbans939563turban_s
unbans81912623_unban_s
wetbacks1974983wetbacks

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.423422437.4
2DLD Change Limit146162697.29620033.2
3Display Results69690.0461500.0
 (SQL Overall)178691697.76523012.4
 
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.