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 “tiros” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

202 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
tiros5452489(None) 
biros75325131biros
giros65722651giros
taros55640821taros
tires55437491tires
tirls54519801tirls
tiro46832361tiro_
toros54336191toros
trios55528091trios
tyros85118591tyros
airns55521032airns
airs46447422air_s
airts55626342airts
bigos85020012bigos
bios66335312bi_os
birds85421332birds
birks114920302birks
birls74023162birls
biro66131202biro_
birrs74917102birrs
brios74725722brios
bros65635662_bros
ceros74726072ceros
chiros114617772chiros
cires74932912cires
didos76820812didos
dinos65428062dinos
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
duros65422692duros
eidos65817752eidos
eros45238452_eros
euros54920242euros
faros85532022faros
fidos95819052fidos
filos86125382filos
finos86226952finos
fires85740752fires
firms105217422firms
firns86018542firns
firs76637712fir_s
girds74816992girds
girls64518392girls
girns64516802girns
giro55828632giro_
giron66118992giron
girons75014372girons
girts65423622girts
guiros7389092guiros
gyros95616482gyros
heros84930862heros
hires86134342hires
ires45639282_ires
iris45732542_iris
irks86220132_irks
iron46728462_iron
irons55324132_irons
kilos95021472kilos
kinos96626142kinos
kirks84915262kirks
kirns95315452kirns
kirs85831732kir_s
lidos65219882lidos
lilos55821872lilos
limos75320812limos
linos55631502linos
liras56021982liras
lirot5430032lirot
micros104115362micros
milos75428012milos
mires75640882mires
mirks115122142mirks
mirs66940562mir_s
misos76523292misos
nitros64214122nitros
pirns76020092pirns
pirog83913672pirog
pisos76021062pisos
pros65742782_pros
pyros105718292pyros
saros55238062saros
silos56029422silos
sires55945372sires
sirs44338332sir_s
stirks104914232stirks
stirps85011812stirps
stirs55921612stir_s
tacos77023552tacos
taos45541002t_aos
tares57456562tares
tarns56433952tarns
taro46846912taro_
taroc75721642taroc
tarocs84615662tarocs
tarok97921072tarok
taroks106115282taroks
tarot55943932tarot
tarots66422992tarots
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
telos55424522telos
terms75523472terms
terns55226872terns
thirds10438602thirds
thirls95012062thirls
thro77726422thro_
throb109816852throb
throbs118311372throbs
throe89321422throe
throes97518672throes
throw118719732throw
throws129715232throws
tiaras6314532tiaras
ticks115823292ticks
tics65729632ti_cs
tides64830152tides
tiers55526522tiers
ties45248312ti_es
tiffs114414882tiffs
tigon63914442tigon
tigons74112252tigons
tikes95628902tikes
tikis95615972tikis
tiles55542102tiles
tills54631702tills
tils45739612ti_ls
tilts55325612tilts
times75630822times
tines54848422tines
tings65329192tings
tins45251302ti_ns
tints56030922tints
tipis76019922tipis
tips66436762ti_ps
tire46143352tir_e
tired65228902tired
tirl45029922tir_l
tis37056642ti__s
titis56023812titis
titres64718932titres
tits46145032ti_ts
topos75726392topos
toras55540372toras
torcs75123762torcs
tores55352672tores
toro48045682toro_
torose64317692torose
torot56139942torot
torous64319022torous
torrs53923562torrs
tors46157382tor_s
torso56922142torso
torsos64815732torsos
torts56138122torts
torus54329762torus
toyos87519142toyos
tres46542902t_res
tries55742812tries
trigos74214172trigos
trigs65423062trigs
trims75021472trims
trio45233342trio_
triol55521362triol
triols66117802triols
triose64715382triose
tripos84014922tripos
trips74923362trips
trod57627952t_rod
trog57628212t_rog
trogs67022602t_rogs
trois57226092t_rois
trop66833302t_rop
trot46351312t_rot
trots56629942t_rots
trow78031422t_row
trows88826182t_rows
troy77429682t_roy
troys86418612t_roys
turbos8910782turbos
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
twirls9478122twirls
twirps11415012twirps
twos76718022t_wos
typos106015812typos
tyres84725232tyres
tyro76622362tyro_
vinos84723072vinos
vireos94212452vireos
vires84529682vires
virls85618602virls
virus85316842virus
winos84625042winos
wires86034912wires
yirds96612512yirds
yirrs8469192yirrs
zeros144918102zeros

Search took 4 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 Filter178691538000.1401276364.3
2DLD Change Limit538002022.70319903.8
3Display Results2022020.1101836.4
 (SQL Overall)1786912022.95360511.7
 
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.