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

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

88 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
outstaying144609(None) 
outsaying1338701outs_aying
outstaring1137801outstaring
outstating1139361outstating
outlaying1338542out_laying
outplaying1645962outplaying
outpraying1646522outpraying
outshaming1645662outshaming
outskating1536852outskating
outsoaring1137702outsoaring
outstanding1344552outstanding
outstarting1245012outstarting
outstudying1642152outstudying
juttying1933573jut_t_ying
ousting84021353ou_st__ing
outbaking1638233out_baking
outbeaming1546043outbeaming
outblazing2245593outblazing
outbraving1646163outbraving
outbuying1545563out_buying
outcrying1576093out_crying
outdaring1179723out_daring
outdating11810863out_dating
outdrawing1546023outdrawing
outeating10814493out_eating
outfacing1578113out_facing
outflying1635343out_flying
outgazing2037143out_gazing
outglaring1246273outglaring
outgnawing1544433outgnawing
outhearing1438443outhearing
outlawing1337933out_lawing
outleading1237133outleading
outleaping1346203outleaping
outlying1248813ou__tlying
outpacing1478363out_pacing
outpitying1644773outpitying
outplacing1546193outplacing
outracing12912163out_racing
outraging111010883out_raging
outrating10916403out_rating
outraving13910133out_raving
outreading1239283outreading
outroaring1138833outroaring
outsailing1137563outsailing
outsang83411273outs_a__ng
outscoring1346233outscoring
outseeing1038333outs_eeing
outselling1188023outselling
outserving1446743outserving
outshining1446533outshining
outsing83320463outs___ing
outsinging1246273outsinging
outsinning1146173outsinning
outsitting1147133outsitting
outsmarting1444383outsmarting
outsmiling1345743outsmiling
outsmoking1745123outsmoking
outsnoring1145613outsnoring
outspanning1443563outspanning
outspeaking1844173outspeaking
outspring1238903outs_pring
outstand938043outsta__nd
outstation1046163outstation
outstations1145343outstations
outstay1047683outstay___
outstayed13185933outstay_ed
outstays1156623outstay__s
outsteering1244553outsteering
outstriding1344203outstriding
outstriving1543793outstriving
outstunting1243783outstunting
outsulking1544723outsulking
outswearing1544073outswearing
outswing1259283outs__wing
outtalking1545483out_talking
outtasking1545723out_tasking
outtrading1247153outtrading
outvying1536063ou__tvying
outwearing1437183outwearing
outwearying1843203outwearying
overstaying1847053overstaying
puttying1434953put_t_ying
staying114017323___staying
unsaying1288153_uns_aying
unstating10711213_unstating
upstaging1344113_upstaging
upstaring1235963_upstaring

Search took 7 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.1561145455.1
2DLD Change Limit140603886.51621578.1
3Display Results88880.0302933.3
 (SQL Overall)178691886.70226662.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.