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 “tubaist” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

118 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
tubaist93870(None) 
tubaists1055101tubaists
tubist83013161tub_ist
cubist104214442cub_ist
subsist9311572subsist
tubas75119582tuba_s_
tubbiest12117292tubbiest
tubists9288322tub_ists
arbalist10313333arbalist
aurist65027253au_rist
autist64324943au_tist
bait66556003__bai_t
baits76630583__baits
bast66362413__ba_st
biblist11310833biblist
bubalis11359903bubalis_
bubals103513843bubals_
bundist10310193bundist
cabalist12314503cabalist
cubbish1635803cubbish
cubism12348703cub_ism
cubists11359023cub_ists
cubit94122893cub_i_t
cubits103714033cub_its
cultist91412713cultist
dadaist9310103dadaist
dualist8614053dualist
duelist8511413duelist
fubsiest13258413fubsiest
fuguist1136073fuguist
hubris11218973hubris_
humanist13410493humanist
jubas144614223juba_s_
judoist1545633judoist
jujuist1343073jujuist
jurist134616393ju_rist
kabalist14410083kabalist
lutanist8410273lutanist
lutist64317553lu_tist
maist75535683__maist
muralist10312983muralist
nubbiest12117313nubbiest
nubias8310093nubias_
nudist73813323nu_dist
oboist8312683_oboist
pubis94616473pub_is_
publish1447913publish
purist85525053pu_rist
quaint15415173qu_aint
quais144618393qu_ais_
qubit164218993qub_i_t
qubits173710353qub_its
querist16311133querist
rebait8320403rebai_t
rebaits9312573rebaits
rubaiyat1343253rubaiyat
rubasse934903rubasse
rubbish1436303rubbish
rubiest92914423rubiest
ruralist8311703ruralist
stubbiest1345483stubbiest
subahs114512383subahs_
subas74724073suba_s_
submiss1138083submiss
submit10312673submi_t
submits1139753submits
subsists1037993subsists
subtest9513963subtest
sumoist9311613sumoist
tabaret92717313tabaret
tabbis102910863tabbis_
tachist12613293tachist
taint55542283t__aint
tanist6324593t_anist
tennist72813113tennist
terais64023513terais_
theist9314763t_heist
tibias839953tibias_
titlist7312923titlist
toast55831013t_oa_st
totalist8315583totalist
tourist7313203tourist
trait56940843t_rai_t
traits65121983t_raits
tribalist1149953tribalist
tsarist7712253tsarist
tuba65422363tuba___
tubae74716643tuba__e
tubal75517203tuba__l
tubate82813173tuba_te
tubbier11237743tubbier
tubbing123510093tubbing
tubers85017033tubers_
tubes74826453tub_es_
tubing93813093tub_ing
tublike1337083tublike
tubs65430063tub__s_
tufas85314383tufa_s_
tuftiest1138283tuftiest
tuis44829643tu__is_
tuladis835703tuladis_
tunas54224123tuna_s_
tundish1137283tundish
turbans939563turbans_
turbit8715113turbi_t
turbits969233turbits
turfiest112410133turfiest
turista737443tu_rista
tussis6379953tussis_
tuttis63611373tuttis_
twist86820983t__wist
typist1139823t_ypist
tzarist1659103tzarist
unais53420773_unais_
urbanist10109073urbanist
utopist938693utopist
vibist11610583vib_ist
waist86132383__waist

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.390458182.1
2DLD Change Limit1340271186.97019229.1
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.40624127.9
 
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.