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

250 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
turnip83659(None) 
turnips935011turnips
turnup835091turnup
burnie83715412burnie
thrip103012182thr_ip
trip66830392t_r_ip
tulip71111692tu_lip
tunic74018222tu_nic
turbid979712turbid
turbit8715112turbit
turgid868012turgid
turn46330382turn__
turned73914472turned
turner63914612turner
turning83713182turning
turnon638192turnon
turns55623232turn_s
turnups933892turnups
unrip72012862_unrip
atrip75315743atr_ip
aurei54821863aurei_
auric74521723aur_ic
auris55331523aur_is
burdie93615023burdie
burin75626063bur_in
burins84221893burins
burlap1098353burlap
burn65636423burn__
burned95818963burned
burner83819203burner
burnet84326173burnet
burnies94017823burnies
burning104215503burning
burnish1238623burnish
burns74926773burn_s
burnt75230323burn_t
burp85028883bur__p
byrnie11348573byrnie
carnie84421093carnie
catnip1097963catnip
coturnix1742193coturnix
curia74523763cur_ia
curie74533033cur_ie
curing94824783curing
curio74221203cur_io
curn66731883curn__
curns74924273curn_s
currie84317253currie
drip76223953_dr_ip
during84419403during
durn56127623durn__
durned84113173durned
durning93511733durning
durns64819863durn_s
durrie73713253durrie
euripi856083eur_ipi
fornix1636033fornix
furnish1337383furnish
garni6315703garni_
genip84415203_genip
grip76127023_gr_ip
guanin7610803guanin
gurnet74920873gurnet
gurney10429413gurney
hernia9312293hernia
lurid64618973lur_id
luring73820753luring
muni65824403mu_ni_
munis75022003mu_nis
muonic10410183muonic
murein8311763murein
murid84520583mur_id
murine84220023murine
muring95120373muring
nip56945983___nip
nudnik1153313nudnik
ornis54616773_ornis
ourie54027293our_ie
parsnip1146323parsnip
pernio8513143pernio
puranic11410483puranic
puri65931443pur_i_
purin75527593pur_in
purine85321893purine
purins83722653purins
puris75332023pur_is
purlin83615863purlin
quinic17319473quinic
quinin152811953quinin
quip154818623qu__ip
rip56851303__r_ip
runic73615773ru_nic
scrip96619193scr_ip
snip66424653__snip
strip77524333str_ip
sunup7313053su_nup
taenia6313193taenia
tannic82811473tannic
tannin62613923tannin
taring73932283taring
tarn46842723tarn__
tarnal63716503tarnal
tarnish101611873tarnish
tarns56433953tarn_s
tarp66936413tar__p
tarsi55222173tarsi_
tarsia65514273tarsia
taurine7311363taurine
tenia55324483t_enia
tennis64015303tennis
terai53525483terai_
terais64023503terais
terbia8311153terbia
terbic10410963terbic
tern46134803tern__
terne56426153tern_e
ternes65422903ternes
ternion739493ternion
terns55226873tern_s
territ63421373territ
threap11569663threap
threep115910113threep
thrips11299013thr_ips
tip56551223t___ip
tiring74023093tiring
tonic74727653t_onic
toonie63617993toonie
tori47542153tor_i_
toric76529313tor_ic
torii55521593tor_ii
torn46044253torn__
toroid7416013toroid
torpid9310913torpid
torrid7311853torrid
torsi57423363torsi_
touring82915193touring
tourney1036273tourney
townie93312303townie
traik95418203t_raik
trail55126773t_rail
train56529113t_rain
trait56940843t_rait
tramp96319773t_ramp
trap67532803t_r_ap
trig55528163t_r_ig
trim65329513t_r_im
trine54734603t_rine
trio45233343t_r_io
tripe75425383t_r_ipe
trips74923363t_r_ips
trois57226093t_rois
tromp95815803t_romp
troop76417533t_roop
trop66833303t_r_op
truing73913933truing
trump95615123t_rump
trunk94713043trun_k
trunks10429753trunks
tsuris62710203tsur_is
tubing93813083tubing
tugrik1134283tugrik
tui37034023tu__i_
tuis44829643tu__is
tulips8137253tu_lips
tumid84114023tu_mid
tump85927033tu__mp
tun35845193tu_n__
tuna45127843tu_n_a
tunas54224123tu_nas
tune45635863tu_n_e
tuned64622313tu_ned
tuner56022683tu_ner
tunes55332193tu_nes
tuneup835203tuneup
tung55328163tu_n_g
tungs65520623tu_ngs
tunica8379813tu_nica
tunics83811263tu_nics
tuning74016843tu_ning
tunned74014493tunned
tunnel64310633tunnel
tunnies73614263tunnies
tunning83514453tunning
tunny86515033tu_nny
tuns45138663tu_n_s
tup56037543tu___p
tupik1149003tu_pik
turaco839453turaco
turban8310483turban
turbine9310303turbine
turbith1267113turbith
turbits969233turbits
turbo71015043tur_bo
turbos8910783turbos
turbot8914263turbot
turd56027623tur__d
turdine8310273turdine
turds65021693tur_ds
tureen63312723tureen
turf75334053tur__f
turfed103110963turfed
turfier10249793turfier
turfing113010053turfing
turfs84620443tur_fs
turfy114315403tur_fy
turgite837973turgite
turgor736863turgor
turion6313163turion
turk86125863tur__k
turkey1337763turkey
turkois1135133turkois
turks95320823tur_ks
turmoil944723turmoil
turners73912893turners
turnery10357423turnery
turnings9287233turnings
turnkey1433013turnkey
turnoff1344013turnoff
turnons737863turnons
turnout7410283turnout
turnpike1442573turnpike
turnspit1043993turnspit
turps74918733tur_ps
turret63121853turret
turtle63213573turtle
turves94212693turves
tushie939723tushie
tussis6379953tussis
tutti54614673tutti_
tuttis63611373tuttis
tyring104613023tyring
tyronic1239313tyronic
tzuris15286913tzur_is
unhip10178823_unhip
unit45140073_u_nit
unrig61711413_unrig
unripe82012093_unripe
unrips8199453_unrips
unzip16207623_unzip
urania62516123_urania
uranic82315183_uranic
urbia7311133_urbia
ureic74514463_ureic
uric63624933_ur_ic
urine55026593_urine
urn35731463_urn__
urns46323893_urn_s
urp56426393_ur__p
ursid6311483_ursid
vernix1636633vernix

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.1401276364.3
2DLD Change Limit1127162505.71619719.4
3Display Results2502500.0803125.0
 (SQL Overall)1786912505.93630102.9
 
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.