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

78 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
ratios6492267(None) 
patios85221791patios
radios74018671radios
ratio55227581ratio_
ration64226011ration
rations74123431rations
ratos55528771rat_os
adios65822862_adios
agios65919862_agios
bathos116215632bathos
batiks1239372batiks
cation83925502cation
cations94524142cations
danios7314602danios
datos65222782dat_os
dattos74311902dattos
fatsos9389422fatsos
gratins84119182gratins
gratis74819242grati_s
jatos125116822jat_os
kation104315682kation
kations114013662kations
latigos8277242latigos
latinos73613802latinos
matins84527782matins
matzos1749262matzos
nation64322802nation
nations74720562nations
oration71617712oration
orations81515802orations
pathos115516692pathos
patins87528782patins
patio74426362patio_
patois84319362patois
rabies85226022rabies
radio64922492radio_
radius73914872radius
ragis66325602ragi_s
raias54631122ra_ias
raids65827522ra_ids
rails55937402ra_ils
rains55140232ra_ins
rais45252622ra_i_s
raitas64417672raitas
rakis95323442raki_s
ramies84630462ramies
ramtils938412ramtils
ranids75118702ranids
ranis55235842rani_s
rapids94913892rapids
ratals64219582ratals
ratans63819372ratans
ratels64518212ratels
raters63936582raters
rates55352012rat_es
ratify122610042ratify
ratine65131822ratine
ratines75328582ratines
rating74938702rating
ratings84217412ratings
ratite65022422ratite
ratites74920682ratites
ratlins73615582ratlins
rato45436972rat_o_
ratoon64417372ratoon
ratoons73815472ratoons
rats46260372rat__s
ratton64116122ratton
rattons73815322rattons
ravins94622562ravins
rawins95617622rawins
reties65436192reties
retros63820192retros
rotis56327062roti_s
rotos56027882rot_os
rutins63818392rutins
satins64930482satins
satis55633682sati_s

Search took 3 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.343520965.0
2DLD Change Limit82551782.53332590.2
3Display Results78780.0302600.0
 (SQL Overall)178691782.90661490.4
 
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.