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

99 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
surtout741167(None) 
surtouts846201surtouts
burgout1049772burgout
burnout9310452burnout
cutout8315922cu_tout
putout8315112pu_tout
setout64719462s_etout
shutout1048532shutout
sprout8419402spr_out
stout57434052s__tout
surcoat9412922surcoat
surmount1045902surmount
turnout7410282turnout
aurous64119263aur_ous
bugout9311863bu_gout
burbot10815653burbo_t
burgouts1145123burgouts
burnous938823burnous
burnouts1045263burnouts
burton8311273burto_n
burtons9310853burtons
butut75522913bu_t_ut
buyout11310103bu_yout
curious93813563curious
curtest9713963curtest
cutouts938033cu_touts
dugout8310363du_gout
furious103110633furious
grout65330423_gr_out
hurtful1344853hurtful
outjut13610073ou_tjut
output8712853ou_tput
outroot7516563outroot
prutot8311823pruto_t
pullout9310593pullout
purport1159393purport
putouts937083pu_touts
rout46153283__r_out
rubout8313563ru_bout
runout6414873ru_nout
santour737373santour
sarcous9312933sarcous
sartor6313883sarto_r
sartors7314973sartors
scout75031453s__cout
scrotum1145133scrotum
seatrout8411583seatrout
sellout7313583sellout
serious73616283serious
serous65023563ser_ous
setous64917373s_etous
setouts74110333s_etouts
shootout1146623shootout
shortcut1344453shortcut
shout85433173s__hout
shroud1038773shr_oud
shutouts1143823shutouts
sickout1359373sickout
slipout949083slipout
snout54530633s__nout
spinout9311583spinout
spout75029633s__pout
sprouts949983spr_outs
spurious1036963spurious
stoat57135953s__toat
stopt76528353s__topt
stot46347333s__to_t
stott56929793s__tott
stoup75517073s__toup
stour54916743s__tour
stouts65019003s__touts
stratous8410703stratous
stroud7310383str_oud
strut56030733s__trut
sublot82315523sublo_t
subtest9513963subtest
subtext1647653subtext
subtone9310343subtone
succour1144693succour
suitor63311053suito_r
suitors73012493suitors
sukkot936643sukko_t
support11310523support
surcoats1047943surcoats
surest65026763sur_est
surfboat1345333surfboat
surfeit10310343surfeit
surmounts1143443surmounts
surplus936793surplus
surround944503surround
surtax1337843surt_ax
tout46753823___tout
trout57332573_tr_out
tryout9410753_tryout
turbot8914263turbo_t
turnouts845413turnouts
urtext1337433_urtext
usurious845273usurious
workout1448393workout

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.390458182.1
2DLD Change Limit134027995.89022755.0
3Display Results99990.0462152.2
 (SQL Overall)178691996.32628247.1
 
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.