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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

79 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
torous6431903(None) 
porous84419481porous
toros54336191toro_s
torus54329761tor_us
amorous9311132amorous
aurous64119262aurous
borons85520542borons
cerous85821202cerous
comous10816502comous
cormous11312352cormous
cornus84816562cornus
corpus106015292corpus
iodous7311502iodous
joyous16276762joyous
morons84919542morons
nodous7711332nodous
odorous837662odorous
parous84024162parous
poyous112911622poyous
serous65023562serous
sorus54527582sor_us
tarocs84615662tarocs
taroks106115282taroks
taros55640822taro_s
tarots66422992tarots
tarsus6310512tarsus
thorons104511912thorons
thous86017262t_hous
throbs118311372throbs
throes97518672throes
throws129715232throws
timorous1047432timorous
tiros54524892tiro_s
tofus86415422to_fus
tolus55024482to_lus
tonus56324302to_nus
tools55325242to_ols
toons55027532to_ons
toots55331872to_ots
tophus115210362tophus
topos75726392topo_s
torahs95115642torahs
toras55540372tor_as
torcs75123762tor_cs
tores55352672tor_es
torics85118352torics
tories65435882tories
toro48045682toro__
toroid7416012toroid
toroids8310642toroids
torose64317692torose
torot56139942toro_t
toroth95512962toroth
torpors939382torpors
torque15237672torque
torques16217512torques
torrs53923562tor_rs
tors46157382tor__s
torses64727952torses
torsks10549122torsks
torsos64815732torsos
tortas64918252tortas
tortes64826052tortes
tortious839022tortious
torts56138122tor_ts
tortuous845902tortuous
toyons95512132toyons
toyos87519142toyo_s
trogs67022602t_rogs
trois57226092t_rois
troops85712782troops
trots56629942t_rots
trout57332572t_rout
trouts66116632t_routs
trows88826182t_rows
troys86418612t_roys
tumorous1046602tumorous
tyros85118592tyro_s
vodous1038602vodous

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 Filter178691825510.1101624463.6
2DLD Change Limit82551793.34324693.7
3Display Results79790.0461717.4
 (SQL Overall)178691793.49951069.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.