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

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

117 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
outstating113936(None) 
outskating1536851outskating
outstaring1137801outstaring
outstarting1245011outstarting
outstaying1446091outstaying
outdating11810862out_dating
outeating10814492out_eating
outrating10916402out_rating
outsaying1338702outs_aying
outshaming1645662outshaming
outsitting1147132outsitting
outsmarting1444382outsmarting
outsoaring1137702outsoaring
outstanding1344552outstanding
outstation1046162outstation
outstations1145342outstations
outstunting1243782outstunting
unstating10711212_unstating
automating1389303automating
butylating1644583butylating
estating92614993__estating
gestating11229983_gestating
instating10812213_instating
lustrating1147783lustrating
misstating13129313misstating
mutating112211753mu__tating
mutilating1349083mutilating
nutating92411953nu__tating
obturating1346573obturating
ousting84021353ou_s__ting
outacting1239213out_acting
outbaking1638233out_baking
outbeaming1546043outbeaming
outblazing2245593outblazing
outbleating1444883outbleating
outboasting1444243outboasting
outbraving1646163outbraving
outcheating1744873outcheating
outdaring1179723out_daring
outdebating1543293outdebating
outdrawing1546023outdrawing
outfacing1578113out_facing
outfasting1446333outfasting
outfeasting1543843outfeasting
outfitting1465823outfitting
outfloating1544363outfloating
outfooting1445653outfooting
outgazing2037143out_gazing
outglaring1246273outglaring
outgnawing1544433outgnawing
outhearing1438443outhearing
outhitting1446333outhitting
outhunting1446143outhunting
outjutting1844263outjutting
outlasting1137523outlasting
outlawing1337933out_lawing
outlaying1338543out_laying
outleading1237133outleading
outleaping1346203outleaping
outpacing1478363out_pacing
outplacing1546193outplacing
outplaying1645963outplaying
outpraying1646523outpraying
outputting1345083outputting
outquoting2064743outquoting
outracing12912163out_racing
outraging111010883out_raging
outraving13910133out_raving
outreading1239283outreading
outroaring1138833outroaring
outrooting1147933outrooting
outsailing1137563outsailing
outsang83411273outs_a__ng
outscoring1346233outscoring
outseeing1038333outs_eeing
outselling1188023outselling
outserving1446743outserving
outshining1446533outshining
outshooting15104153outshooting
outshouting1583813outshouting
outsing83320463outs___ing
outsinging1246273outsinging
outsinning1146173outsinning
outsmiling1345743outsmiling
outsmoking1745123outsmoking
outsnoring1145613outsnoring
outspanning1443563outspanning
outspeaking1844173outspeaking
outspring1238903outs_pring
outstand938043outsta__nd
outstate81411993outstat__e
outstated10169813outstat_ed
outstates91710753outstat_es
outsteering1244553outsteering
outstriding1344203outstriding
outstriving1543793outstriving
outstudying1642153outstudying
outsulking1544723outsulking
outswearing1544073outswearing
outswing1259283outs__wing
outtalking1545483out_talking
outtasking1545723out_tasking
outtrading1247153outtrading
outvoting1336823out_voting
outwaiting1446733outwaiting
outwasting1446433outwasting
outwearing1437183outwearing
outwitting1445553outwitting
outwriting1447183outwriting
overstating15410733overstating
pulsating1236343puls_ating
restating102319413_restating
stating83725163___stating
unseating10713203_unseating
upstaging1344113_upstaging
upstaring1235963_upstaring
upstarting1343883_upstarting

Search took 6 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031175.42325927.2
3Display Results1171170.0631857.1
 (SQL Overall)1786911175.90630255.8
 
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.