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

221 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
turnips93501(None) 
turnip836591turnip_
turnups933891turnups
burnies94017822burnies
thrips11299012thr_ips
trips74923362t_r_ips
tulips8137252tu_lips
tunics83811262tu_nics
tunnies73614262tunnies
turbits969232turbits
turners73912892turners
turning83713182turning
turnings9287232turnings
turnons737862turnons
turns55623242turn__s
turnup835092turnup_
turps74918732tur__ps
unrips8199452_unrips
auris55331533aur_i_s
bunnies94415003bunnies
burdies104117563burdies
buries84633273bur_ies
burins84221893bur_ins
burlaps1156253burlaps
burners94115673burners
burnets93813263burnets
burnie83715413burni_e
burning104215503burning
burnings11387623burnings
burnish1238623burnish
burnous938823burnous
burns74926783burn__s
burps94220173bur__ps
byrnies12378573byrnies
carnies94123963carnies
catnips1195893catnips
curies84934023cur_ies
curios83218333cur_ios
curns74924283curn__s
curries93723163curries
drips85417233_dr_ips
durning93511733durning
durns64819873durn__s
durries83817353durries
euripi856083eur_ipi
euripus934623eur_ipus
funnies104113603funnies
furies95126373fur_ies
furnish1337383furnish
genips9469943_genips
grips85520133_gr_ips
guanins8810013guanins
gunnies83413123gunnies
gurnets84010793gurnets
gurneys11406463gurneys
gurries83515953gurries
hernias10310773hernias
hurdies114015663hurdies
hurlies103315333hurlies
hurries103919653hurries
juries134120633jur_ies
lunies64723013lu_nies
munis75022003mu_ni_s
mureins9310733mureins
murids93212193mur_ids
murines93718223murines
murries94118673murries
nips65830933___nips
nudniks1262333nudniks
ornis54616773_orni_s
parsnips1245533parsnips
purines94420773purines
purins83722653pur_ins
puris75332023pur_i_s
purlins93415423purlins
quinins162811293quinins
quips164713373qu__ips
rips66237443__r_ips
scrips105316033scr_ips
snips75818013__snips
strips85719653str_ips
sturdies92110273sturdies
sunups837263su_nups
taenias7311283taenias
tannins72813223tannins
tardies84225863tardies
tarnish101611883tarnish
tarns56433953tarn__s
tarps76527123tar__ps
tarries73324263tarries
tarsias74013373tarsias
taurines8310553taurines
tawnies102812503tawnies
tenias64720073t_enias
tennies73017973tennies
tennis64015303tenni_s
terais64023513terai_s
terbias9310743terbias
ternes65422903tern_es
ternion739493ternion
ternions838813ternions
terns55226873tern__s
terries73425633terries
territs72714503territs
threaps12488643threaps
threeps12687043threeps
thrip103012183thr_ip_
tinsnips1043733tinsnips
tips66436773t___ips
tonics83617863t_onics
toonies73719883toonies
torics85118353tor_ics
tories65435883tor_ies
toroids8310653toroids
torpids1037373torpids
tourings9277373tourings
tourneys1134013tourneys
townies103113623townies
traiks104013713t_raiks
trails64622513t_rails
trains64725343t_rains
traipse935873t_raipse
traits65121983t_raits
tramps105114453t_ramps
traps75727483t_r_aps
tries55742813t_r_ies
trigs65423063t_r_igs
trims75021473t_r_ims
trines64132563t_rines
trios55528093t_r_ios
trip66830393t_r_ip_
tripe75425383t_r_ipe
tripes85324873t_r_ipes
tripos84014923t_r_ipos
trois57226093t_roi_s
tromps104911703t_romps
troops85712783t_roops
trumps104611883t_rumps
trunks10429753trun_ks
tsuris62710203tsur_i_s
tubings10336483tubings
tugriks1233153tugriks
tuis44829643tu__i_s
tulip71111693tu_lip_
tummies113012033tummies
tumps95420793tu__mps
tunas54224123tu_n_as
tuners64417343tu_ners
tunes55332193tu_n_es
tuneups933333tuneups
tungs65520633tu_n_gs
tunic74018223tu_ni_c
tunica8379813tu_nica
tuning74016843tu_ning
tunnels7328723tunnels
tunning83514453tunning
tuns45138663tu_n__s
tupiks1235493tu_piks
tups65628763tu___ps
turacos938643turacos
turbans939563turbans
turbid979713turbi_d
turbine9310303turbine
turbines1039903turbines
turbit8715113turbi_t
turbith1267113turbith
turbiths1374083turbiths
turbos8910783tur_bos
turbots988023turbots
turdine8310283turdine
turds65021693tur__ds
tureens7289873tureens
turfier10249793turfier
turfiest112410133turfiest
turfing113010053turfing
turfs84620443tur__fs
turgid868023turgi_d
turgite837973turgite
turgites937783turgites
turgors836833turgors
turion6313163tur_ion
turions7311573turions
turkeys1434523turkeys
turkois1135133turkois
turks95320823tur__ks
turmoils1043983turmoils
turn46330393turn___
turned73914473turn_ed
turner63914613turn_er
turneries948493turneries
turnery10357423turnery
turnkey1433013turnkey
turnkeys1542123turnkeys
turnoff1344013turnoff
turnoffs1442833turnoffs
turnon638193turn_on
turnout7410283turnout
turnouts845413turnouts
turnpike1442573turnpike
turnpikes1542273turnpikes
turnspit1043993turnspit
turnspits1142573turnspits
turrets73010673turrets
turtles72914343turtles
turves94212693tur_ves
tushies10312163tushies
tussis6379953tussi_s
tutties73216473tutties
tuttis63611373tutti_s
tzuris15286913tzur_i_s
units54923433_u_nits
unrigs7159003_unrigs
unrip72012863_unrip_
unripe82012093_unripe
unzips17175273_unzips
uranias72113813_uranias
urbias839093_urbias
urines64724123_urines
urns46323903_urn__s
urps66920483_ur__ps
ursids737823_ursids

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.436409841.7
2DLD Change Limit1340272216.84319586.0
3Display Results2212210.0802762.5
 (SQL Overall)1786912217.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.