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

295 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
toros5433619(None) 
taros55640821taros
tiros54524891tiros
topos75726391topos
toras55540371toras
torcs75123761torcs
tores55352671tores
toro48045681toro_
torose64317691torose
torot56139941torot
torous64319021torous
torrs53923561torrs
tors46157381tor_s
torso56922141torso
torsos64815731torsos
torts56138121torts
torus54329761torus
toyos87519141toyos
tyros85118591tyros
biros75325132biros
bohos105618252bohos
bolos75531372bolos
boors74325012boors
boos67955032bo_os
boras75938302boras
bores76448252bores
borks115727702borks
boron76727142boron
borons85520542borons
borts76735452borts
boyos105418282boyos
bozos165216862bozos
broos75126412broos
bros65635662_bros
ceros74726072ceros
cocos95624692cocos
cohos105921852cohos
coos67456492co_os
cords86030622cords
cores76361852cores
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
dobros93910232dobros
dodos75819392dodos
dojos135111792dojos
doors65022132doors
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
duros65422692duros
eros45238452_eros
euros54920242euros
faros85532022faros
forbs105720802forbs
fords95328182fords
fores85847102fores
forks125324682forks
forms105327052forms
forts86034452forts
giros65722652giros
gobos86219372gobos
gogos77516522gogos
goos57644912go_os
gores65740372gores
gorms85619592gorms
gorps85316992gorps
gyros95616482gyros
heros84930862heros
hobos106321352hobos
homos105921782homos
horas86333092horas
horns86125332horns
kobos115616892kobos
kolos94921212kolos
koras95927112koras
kors85933012kor_s
kotos95717692kotos
kouros1039182kouros
lobos75921842lobos
locos75822602locos
logos67225332logos
loos49051122lo_os
lords64923502lords
lores55045402lores
loris55329152loris
lotos54724632lotos
mojos145314462mojos
monos75930862monos
moors74923142moors
moos66051302mo_os
moras76438762moras
mores76249642mores
morns75527442morns
moron76925422moron
morons84919542morons
morose85116242morose
morros83714672morros
mors65950062mor_s
morts75533562morts
mozos165516332mozos
nolos54423352nolos
nomos75919742nomos
noris54928272noris
norms76019302norms
onos46229002_onos
orbs66626252_orbs
orcs67025432_orcs
ordos65216202_ordos
ores46056682_ores
ors35750112_or_s
orts46538332_orts
orzos143311252_orzos
ottos54714322ottos
polos76129912polos
pomos95321582pomos
poos65949112po_os
pores75849032pores
porks115124142porks
pornos85015252pornos
porns75527342porns
porose84818742porose
porous84419482porous
ports75934592ports
pros65742782_pros
pyros105718292pyros
rotos56027882rotos
saros55238062saros
solos54830792solos
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sores55454282sores
sorgos74514662sorgos
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
stores65533642stores
storks106115932storks
storms85814612storms
tacos77023552tacos
taos45541002t_aos
tares57456562tares
tarns56433952tarns
taro46846912taro_
taroc75721642taroc
tarocs84615662tarocs
tarok97921072tarok
taroks106115282taroks
tarot55943932tarot
tarots66422992tarots
tarps76527112tarps
tars46763952tar_s
tarts57242022tarts
telos55424522telos
terms75523472terms
terns55226872terns
tholos94213002tholos
thorns95314092thorns
thoro86217872thoro_
thoron94713902thoron
thorons104511912thorons
thorps113610892thorps
thro77726422thro_
throb109816852throb
throbs118311372throbs
throe89321422throe
throes97518672throes
throw118719732throw
throws129715232throws
tires55437492tires
tirls54519802tirls
tiro46832362tiro_
toads65621062toads
tods56141842to_ds
toeas55726422toeas
toes46956442to_es
toffs116016722toffs
tofts84919242tofts
tofus86415422tofus
togas67823002togas
togs57242432to_gs
toils54527492toils
toits55327472toits
tokes95234972tokes
tolas54532772tolas
toles55147132toles
tolls54728432tolls
tolus55024482tolus
tombs97818732tombs
tomes76037382tomes
toms68343492to_ms
tondos75115912tondos
tones56048662tones
tongs65928462tongs
tons46553052to_ns
tonus56324302tonus
too38965422to_o_
took86531072to_ok
tool46735682to_ol
tools55325242tools
toom66532932to_om
toon47740632to_on
toons55027532toons
toot45958882to_ot
toots55331872toots
topes76941762topes
tophs105220052tophs
topis76025832topis
topo66932402topo_
topoi76018352topoi
tops66248122to_ps
tor39261682tor__
tora47545992tor_a
torah87125272torah
torahs95115642torahs
torc66333352tor_c
torch107420932torch
tore47359322tor_e
toreros7311342toreros
tori47542152tor_i
toric76529312toric
torics85118352torics
tories65435882tories
torii55521592torii
torn46044252tor_n
toroid7416012toroid
toroids8310642toroids
toroth95512962toroth
torpor839192torpor
torpors939372torpors
torr45630902tor_r
torse55833332torse
torses64727952torses
torsi57423362torsi
torsk94915772torsk
torsks10549122torsks
tort46967462tor_t
torta55925352torta
tortas64918252tortas
torte55431702torte
tortes64826052tortes
tory75840542tor_y
toss45637972to_ss
totes55139682totes
tots46654122to_ts
tours55325862tours
touts54830392touts
towns86018882towns
tows78545552to_ws
toyo76925452toyo_
toyon86715672toyon
toyons95512132toyons
toys78036342to_ys
tres46542902t_res
trios55528092trios
trod57627952t_rod
trog57628212t_rog
trogs67022602trogs
trois57226092trois
troop76417532troop
troops85712772troops
trooz145016152trooz
trop66833302t_rop
trot46351312t_rot
trots56629942trots
trow78031422t_row
trows88826182trows
troy77429682t_roy
troys86418612troys
tsores65113662tsores
tsoris63411192tsoris
turbos8910782turbos
turds65021692turds
turfs84620442turfs
turks95320822turks
turns55623232turns
turps74918732turps
twos76718022t_wos
typos106015812typos
tyres84725232tyres
tyro76622362tyro_
woos76238802wo_os
words95425072words
works125621902works
worms105320752worms
worts88631182worts
yores85031322yores
zeros144918102zeros
zoos135828802zo_os
zoris145320012zoris

Search took 2 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.0931921408.6
2DLD Change Limit538002951.56334421.0
3Display Results2952950.0763881.6
 (SQL Overall)1786912951.732103170.3
 
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.