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

94 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
krubut124555(None) 
krubuts1343011krubuts
kraut95221402kr_aut
krubi1136522krub_i
krubis1235002krubis
rebut75927382_rebut
rubout8313562_rubout
rubus76415062_rubus
abut66834953__abut
arbute8311043ar_bute
barbut104617003barbut
bruit76126723bru_it
brulot8912213brulot
brunet84419293brunet
brunt75728753bru_nt
brut66537963br__ut
bubu85022673_bubu_
bubus95115453_bubus
burbot10815653burbot
but55963023___but
butut75522913_butut
cruet74831843cru_et
crumbum1543743crumbum
cruset84425093cruset
crust75827663cru_st
cubit94122893_cubit
debut86024143_debut
doubt8720093doub_t
drub75920133drub__
drubs85913833drub_s
eruct74022353eru_ct
erupt74220063eru_pt
fruit85122223fru_it
grout65330423gr_out
grub77220083grub__
grubby14324503grubby
grubs86312603grub_s
grunt65523543gru_nt
hagbut1278923hagbut
kaput11717063k_aput
kibbutz2442533kibbutz
knout95018263k_nout
knubby1742783knubby
kombu1347243kombu_
kombus1435523kombus
kraft125721013kr_aft
krait94726773kr_ait
krauts10418513kr_auts
kronur10415313kronur
kudu95815433k_udu_
kudus104910803k_udus
kuru85521803k_uru_
kurus98015633k_urus
orbit73622063or_bit
prebuy1357423prebuy
precut102016533precut
probit103218353probit
prunus8399363prunus
prutot8311823prutot
qubit164218993_qubit
rabat72832223_rabat
rebus75721113_rebus
rebuts84015193_rebuts
rebuy104714683_rebuy
recut74729243_recut
robot7325973_robot
robust8310433_robust
rout46153283_r_out
rub56342823_rub__
rubati8299693_rubati
rubato8319683_rubato
rubby124413863_rubby
rube65532013_rub_e
rubel75416833_rubel
rubes74928413_rubes
ruble74521253_ruble
rubouts937983_rubouts
rubs66133493_rub_s
ruby97819943_rub_y
runout6414873_runout
runt46647983_ru_nt
rust45544913_ru_st
rut35560523_r__ut
sacbut10811943sacbut
sagbut959753sagbut
thruput1243863thruput
tribute937313tribute
trout57332573tr_out
truant6315783truant
truest64816193truest
trust55426853tru_st
tryout9410753tryout
turbit8715113turbit
turbot8914263turbot

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit112716945.20321663.7
3Display Results94940.0332848.5
 (SQL Overall)178691945.60931857.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.