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

109 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
ratines7532858(None) 
patines95225761patines
rapines95120861rapines
ratine65131821ratine_
ratings84217411ratings
ratites74920681ratites
ratlines83815291ratlines
ravines104220231ravines
retines75134671retines
alines65735222_alines
amines84727982_amines
arsines73518812arsines
artiness81615402artiness
atones65225772_atones
azines155517072_azines
canines93724032canines
creatines112814432creatines
datives11310072datives
eatings84616442eatings
famines123216262famines
gamines103618462gamines
gatings95212822gatings
gradines103615252gradines
gratine84719192gratine_
gratinee93710782gratinee
gratinees10307322gratinees
gratings103910762gratings
gratins84119182gratin_s
intines7921112intines
isatines8310662isatines
latices9313762latices
latinas74416462latinas
latinos73613802latinos
latrines8515012latrines
lawines103313562lawines
malines93625602malines
marines93928012marines
matinee92415612matinee
matinees102110422matinees
matiness102114752matiness
matings104516212matings
matins84527782matin_s
mutines93117822mutines
natives10310822natives
patinas96318522patinas
patine85328122patine_
patined105114782patined
patins87528782patin_s
pralines102217722pralines
rabies85226022rabi_es
raciness102413452raciness
racings105015132racings
radices102314262radices
radixes15259342radixes
ragtimes1135822ragtimes
rained75024602ra_ined
rains55140232ra_in_s
raises64826542ra_ises
ramies84630462rami_es
rapine85023082rapine_
ratanies8312922ratanies
ratans63819372ratan_s
ratches123620462ratches
rates55352012rat__es
ratfinks1542852ratfinks
ratifies11313512ratifies
rating74938702ratin_g
rationed9410092rationed
rations74123432rations
ratios64922672rati_os
ratite65022422ratite_
ratline74517802ratline_
ratlins73615582ratlin_s
rattens74213402rattens
rattles73217302rattles
ravine95522222ravine_
ravined115411822ravined
ravings114614502ravings
ravins94622562ravin_s
rawins95617622rawin_s
refines105426342refines
relines75331322relines
repines94927382repines
retenes76324622retenes
reties65436192reti_es
retiles74426992retiles
retimes95020172retimes
retinas74819352retinas
retine66237332retine_
retints74717012retints
retinues85113152retinues
retires74726212retires
retunes76918402retunes
rexines144719152rexines
routines82214362routines
rutiles74315842rutiles
rutins63818392rutin_s
sabines94318482sabines
salines74029412salines
saltines82917792saltines
satinet7325282satinet
satinets8311732satinets
satins64930482satin_s
satires72617572satires
savines104417632savines
tines54848422__tines
vahines133410522vahines
valines104520212valines
wahines133111172wahines

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 Filter1786911076710.376475242.0
2DLD Change Limit1076711093.15634116.3
3Display Results1091090.0303633.3
 (SQL Overall)1786911093.56250165.9
 
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.