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

126 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
outhearing143844(None) 
outwearing1437181outwearing
outbeaming1546042outbeaming
outcheating1744872outcheating
outdaring1179722out_daring
outearning1146742out_earning
outeating10814492out_eating
outglaring1246272outglaring
outleading1237132outleading
outleaping1346202outleaping
outlearning1243542outlearning
outreading1239282outreading
outroaring1138832outroaring
outsoaring1137702outsoaring
outstaring1137802outstaring
outswearing1544072outswearing
outwearying1843202outwearying
wuthering1697802wuthe_ring
authoring1348583auth_oring
bothering152210203bothe_ring
butchering1844503butche_ring
buttering122312533butte_ring
dithering1499853dithe_ring
fathering161010093fathe_ring
furthering1744353furthe_ring
gathering1499463gathe_ring
guttering112410443gutte_ring
hearing113324163___hearing
lathering13912253lathe_ring
mishearing1647883mishearing
mothering152110183mothe_ring
murthering1644473murthe_ring
muttering122611323mutte_ring
ochering14219393o_che_ring
outbaking1638233out_baking
outbarking1746213out_barking
outbegging1544013outbegging
outblazing2245593outblazing
outbleating1444883outbleating
outbraving1646163outbraving
outcharging1843783outcharging
outcharming1943583outcharming
outdating11810863out_dating
outdebating1543293outdebating
outdrawing1546023outdrawing
outdreaming1544233outdreaming
outearn7310683out_ear_n_
outearns838403out_ear_ns
outfacing1578113out_facing
outfeasting1543843outfeasting
outfeeling1445073outfeeling
outfencing1645293outfencing
outfiring1338163out_firing
outgazing2037143out_gazing
outgleaming1542533outgleaming
outgnawing1544433outgnawing
outhear10910603outhear___
outheard1288543outhear__d
outhears11810393outhear__s
outhitting1446333outhitting
outhomering1743903outhomering
outhowling1745183outhowling
outhumoring1752403outhumoring
outhunting1446143outhunting
outkeeping1744263outkeeping
outlawing1337933out_lawing
outlaying1338543out_laying
outlearn836433outlear_n_
outlearns944633outlear_ns
outlearnt945963outlear_nt
outpacing1478363out_pacing
outplacing1546193outplacing
outplaying1645963outplaying
outpouring1346043outpouring
outpraying1646523outpraying
outracing12912163out_racing
outraging111010883out_raging
outrating10916403out_rating
outraving13910133out_raving
outreaching1744913outreaching
outring84021023out___ring
outsaying1338703out_saying
outscoring1346233outscoring
outseeing1038333outse_eing
outselling1188023outselling
outserving1446743outserving
outshaming1645663outshaming
outskating1536853outskating
outsmarting1444383outsmarting
outsnoring1145613outsnoring
outspeaking1844173outspeaking
outspring1238903out_spring
outstarting1245013outstarting
outstating1139363outstating
outstaying1446093outstaying
outsteering1244553outsteering
outtelling11107133outtelling
outtrading1247153outtrading
outwarring1445363outwarring
outwearied1444083outwearied
outwearies1345353outwearies
outweeping1644463outweeping
outyelling14116143outyelling
outyelping16123973outyelping
overhearing1847843overhearing
pothering151911283pothe_ring
puttering122611643putte_ring
rehearing132211763_rehearing
retearing102214253ret_earing
scouthering1743483scouthe_ring
shearing123915903__shearing
subheading1743793subheading
tearing84021493__t_earing
tethering1339133tethe_ring
unbearing1239353_unbearing
unfearing1338883_unfearing
upbearing1435033_upbearing
upheaping1743853_upheaping
upheaving1843803_upheaving
uprearing1238373_uprearing
uptearing1236103_uptearing
ushering1258923_ushe_ring
uttering91613083_utte_ring
vouchering1943653vouche_ring
withering16108813withe_ring
youthening1743723youthe_ning

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.436409841.7
2DLD Change Limit1406031266.45321788.8
3Display Results1261260.0632000.0
 (SQL Overall)1786911266.95225703.5
 
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.