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

63 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
tuxedos154329(None) 
tuxedo1433131tuxedo_
tuxedoes1642751tuxedoes
teredos839182teredos
toledos8388862toledos
tupelos936112tupelos
tuxedoed1741742tuxedoed
tuxes124316042tuxe__s
uredos73910622_uredos
albedos1075253albedos
auxeses1435623auxeses
auxesis1445443auxesis
buteos84913413bute_os
comedos12329073comedos
credos94612853_credos
dukedom1542773dukedom
dukedoms1642393dukedoms
exodos1435943_exodos
judos134711733ju__dos
kudos105011253ku__dos
luxes124921503luxe__s
pumelos11196093pumelos
redos65126763__redos
reredos838633reredos
speedos10298263speedos
suedes73918113su_edes
taxed135620293taxed__
taxemes1635853taxemes
taxers134015283taxe_rs
taxes124730823taxe__s
teds54932573t__ed_s
teledus835093teledus
telos55424523t__elos
teredo7310783teredo_
toledo7419993toledo_
tondos75115923t_ondos
toreros7311343toreros
torpedos1143933torpedos
tournedos1042533tournedos
tubed85818043tubed__
tubenose1094233tubenose
tuberose1095323tuberose
tuberous1047493tuberous
tubers85017033tube_rs
tubes74826453tube__s
tuladis835703tuladis
tules54532793tule__s
tuned64622313tuned__
tuners64417343tune_rs
tunes55332193tune__s
tuneups933333tuneups
tupelo836483tupelo_
turacos938643turacos
turbos8910783tu_rbos
turds65021693tu_rd_s
tureens7289873tureens
tutees6514553tute_es
tuyeres10417793tuyeres
tuyers94612563tuye_rs
tweeds10498433tweed_s
udos56619903_u__dos
updos8389513_u_pdos
uredo65112993_uredo_

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 Filter1786911340270.406440125.6
2DLD Change Limit134027635.56324092.6
3Display Results63630.0163937.5
 (SQL Overall)178691635.98529856.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.