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

167 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
turnup83509(None) 
turnip836591turnip
turnups933891turnups
sunup7313052su_nup
tuneup835202tuneup
turn46330382turn__
turned73914472turned
turner63914612turner
turnips935012turnips
turnon638192turnon
turnout7410282turnout
turns55623232turn_s
aureus65314883aureus
aurous64119263aurous
aurum7614963aur_um
burlap1098353burlap
burn65636423burn__
burned95818963burned
burner83819203burner
burnet84326173burnet
burnie83715413burnie
burnous938823burnous
burnout9310453burnout
burns74926773burn_s
burnt75230323burn_t
burp85028883bur__p
cornu75921323cornu_
cornua85411903cornua
cornus84816563cornus
croup95616783_croup
curium10312503curium
curn66731883curn__
curns74924273curn_s
cutup9410093cu_tup
durn56127623durn__
durned84113173durned
durns64819863durn_s
durum8513203dur_um
dustup935363dustup
fuckup1733963fuckup
furfur1235553furfur
group85413923_group
gurnet74920873gurnet
gurney10429413gurney
guru54623913gur_u_
gurus64318193gur_us
kuru85521803kur_u_
kurus98015633kur_us
larrup835713larrup
markup1436903markup
murmur1034853murmur
pinup9612883_pinup
prunus8399363prunus
pullup1045893pullup
pursue84512253pursue
pushup1335273pushup
roup66627693__roup
sannup836563sannup
sirup74014913sir_up
startup934963startup
sternum947733sternum
stirrup943003stirrup
sunups837263su_nups
syrup103010963syr_up
takeup1234583takeup
tarn46842723tarn__
tarnal63716503tarnal
tarns56433953tarn_s
tarp66936413tar__p
tarsus6310513tarsus
teacup1036253teacup
tergum937933tergum
tern46134803tern__
terne56426153tern_e
ternes65422903ternes
terns55226873tern_s
threap11569663threap
threep115910113threep
thrip103012183thr_ip
thru76818943thr_u_
thrum104713633thr_um
tittup834203tittup
tonus56324303t_onus
torn46044253torn__
torous64319023torous
torque15237673torque
torus54329763tor_us
tossup875293tossup
touchup1443833touchup
tourney1036273tourney
tramp96319773t_ramp
trap67532803t_r_ap
trip66830393t_r_ip
tromp95815803t_romp
troop76417533t_roop
trop66833303t_r_op
troupe84812433t_roupe
trout57332573t_rout
true46725853t_r_ue
trug55720043t_r_ug
trump95615123t_rump
trunk94713043trun_k
trunks10429753trunks
tubful1136683tubful
tuchun1145443tuchun
tulip71111693tu_lip
tumour8137393tumour
tump85927033tu__mp
tun35845193tu_n__
tuna45127843tu_n_a
tunas54224123tu_nas
tune45635863tu_n_e
tuned64622313tu_ned
tuner56022683tu_ner
tunes55332193tu_nes
tuneups933333tuneups
tung55328163tu_n_g
tungs65520623tu_ngs
tunic74018223tu_nic
tunned74014493tunned
tunnel64310633tunnel
tunny86515033tu_nny
tuns45138663tu_n_s
tup56037543t___up
tuque14469193tu_que
turaco839453turaco
turban8310483turban
turbid979713turbid
turbit8715113turbit
turbo71015043tur_bo
turbos8910783turbos
turbot8914263turbot
turd56027623tur__d
turds65021693tur_ds
tureen63312723tureen
turf75334053tur__f
turfed103110963turfed
turfs84620443tur_fs
turfy114315403tur_fy
turgid868013turgid
turgor736863turgor
turion6313163turion
turk86125863tur__k
turkey1337763turkey
turks95320823tur_ks
turners73912893turners
turnery10357423turnery
turning83713183turning
turnkey1433013turnkey
turnoff1344013turnoff
turnons737863turnons
turnouts845403turnouts
turnspit1043993turnspit
turps74918733tur_ps
turret63121853turret
turtle63213573turtle
turves94212693turves
tussur6357293tussur
tutu48423173tu_tu_
tutus55214813tu_tus
unrip72012863_unrip
urn35731463_urn__
urns46323893_urn_s
urp56426393_ur__p
urus46426133_ur_us
warmup1335343warmup
workup1534323workup

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 Filter1786911127160.1401276364.3
2DLD Change Limit1127161676.39017639.4
3Display Results1671670.0463630.4
 (SQL Overall)1786911676.57627173.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.