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

115 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
outstart8161128(None) 
outsmart10168921outsmart
outstare81410691outstare
outstarts9176321outstarts
outsat62920282outs_a_t
outsert72819512outs_ert
outskirt1246642outskirt
outsmarts11155142outsmarts
outsoar739492outsoar_
outsoars838852outsoars
outstand938042outstand
outstared10188422outstared
outstares91610182outstares
outstarted1155072outstarted
outstate81411992outstate
outstay1047682outsta_y
outstays1156622outstays
outstunt847222outstunt
outsware11168842outsware
upstart9159752_upstart
bustard10389723bu_stard
custard10389973cu_stard
misstart10410033misstart
mouthpart1643823mouthpart
mustard10359533mu_stard
ottar54313993o_t_tar_
ottars64112223o_t_tars
ouster64223733ou_ster_
ousters74122793ou_sters
outact8317203ou__tact
outbark1339453out_bark
outboard1138323outboard
outboast1048543outboast
outcast91013743out_cast
outcharm1544733outcharm
outdare83113403out_dare
outearn7310683out_earn
outeat62824533out_ea_t
outfast101412123out_fast
outfeast11107503outfeast
outglare937383outglare
outhear10910603outhear_
outheard1288543outheard
outhears11810393outhears
outlast71015443out_last
outleapt10318153outleapt
outlearn836433outlearn
outlearnt945963outlearnt
outport9714123out_port
outroar739513outroar_
outroars838923outroars
outsaid81210923outs_aid
outsail71411413outs_ail
outsang83411273outs_ang
outsaw92610283outs_a_w
outsay92611873outs_a_y
outsays102710403outs_ays
outscore10169203outscore
outscorn10166143outscorn
outserts8309803outs_erts
outset64027453outs__et
outshame1346743outshame
outshoot1149163outshoot
outshot10312103outs_hot
outshout1149493outshout
outsight1246913outsight
outsit63620893outs__it
outskate12168013outskate
outskirts1343513outskirts
outslept1047703outslept
outsmarted1344323outsmarted
outsmelt10138163outsmelt
outsnore8187683outsnore
outsoared10157593outsoared
outspan938743outspa_n
outspans1038223outspans
outspelt10148403outspelt
outspent101310213outspent
outstands1045543outstands
outstaring1137803outstaring
outstarting1245013outstarting
outstated10169813outstated
outstates91710753outstates
outstayed13185933outstayed
outsteer837553outsteer
outsteers936033outsteers
outstood945933outstood
outstrip1045083outstrip
outstudy1242923outstudy
outstunts943613outstunts
outswam1246613outswa_m
outswear1144793outswear_
outswears1244303outswears
outswept1346383outswept
outswore11168673outswore
outsworn11166663outsworn
outtake11310793out_take
outtalk1138233out_talk
outtask1137053out_task
outtrot7312613out_trot
outturn737123out_turn
outwait10411763out_wait
outwar91011513out_war_
outward11811403out_ward
outwars10912793out_wars
outwear1097713outwear_
outwears1197263outwears
outweary1485393outweary
overtart11312493overtart
redstart949193redstart
restart7320033_restart
start55642313___start
unsmart939603_unsmart
upstare9158683_upstare
upstarts10165273_upstarts

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.406440125.6
2DLD Change Limit1461621157.29620033.2
3Display Results1151150.0462500.0
 (SQL Overall)1786911157.74823062.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.