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

167 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
outearns83840(None) 
outearn7310681outearn_
outlearns944631outlearns
outbarks1437832outbarks
outburns1036062outburns
outdares92712462outdares
outearned1056682outearned
outeats72215702outea_ts
outers64230172oute_r_s
outfawns1434722outfawns
outgains9810162outgains
outhears11810392outhear_s
outlearn836432outlearn_
outlearnt945962outlearnt
outmans92413282outma_ns
outturns835912outturns
outwards1299122outwards
outwars10912792outwar_s
outwears1197262outwear_s
auteurs7137503auteur_s
caterans10313223caterans
couters93827303coute_r_s
earns55927563___earns
externs1438233exte_rns
futharcs1653153futharcs
futharks1843783futharks
interns73116773inte_rns
learns65513743__learns
lucerns935753luce_rns
luteins7310103lute_ins
lutherns1136293lutherns
oaters65029793oate_r_s
obtains939163obt_ains
oceans81211003o_cea_ns
octans81411143oct_a_ns
ostmarks1443893ostmarks
ottars64112223o_ttar_s
otters64021513otte_r_s
ouabains1044363ouabains
ouraris73512933ou_raris
ousters74122793ouste_r_s
outacts9310213out_acts
outadds936203out_adds
outages82317323out_ages
outasks1138173out_asks
outbacks1638983outbacks
outbakes1439993outbakes
outbark1339453outbar_k
outbawls1336053outbawls
outbeams1236063outbea_ms
outboards1246213outboards
outbrags1136693outbrags
outburn936903outburn_
outburnt1057153outburnt
outcalls1038743outcalls
outcasts10108683outcasts
outcharms1643923outcharms
outdare83113403outdar_e
outdared102711513outdared
outdaring1179723outdaring
outdates93114743outdates
outdrags1046583outdrags
outdrank1345433outdrank
outdraws1236233outdraws
outearning1146743outearning
outeat62824533outea__t
outeaten8310423outeaten
outeating10814493outeating
outer55633303oute_r__
outfaces132311393outfaces
outfalls1138143outfalls
outfasts11117233outfasts
outfawn1335983outfawn_
outfeasts12114333outfeasts
outfires1139863outfires
outgain81010743outgain_
outgas7313203outga__s
outgazes18248713outgazes
outglares1047003outglares
outgrins979823outgrins
outguns8318693out_guns
outhauls1137223outhauls
outhear10910603outhear__
outheard1288543outhear_d
outhearing1438443outhearing
outlain71212613outlain_
outland81212343outla_nd
outlands988563outlands
outlasts8108713outlasts
outlaws10249603outla_ws
outlays102610903outla_ys
outleads9278763outlea_ds
outleaps10237073outlea_ps
outlearned1143623outlearned
outman83115033outma_n_
outmarch1544793outmarch
outpaces122411943outpaces
outpaint10311773outpaint
outpaints1145283outpaints
outpass939713outpa_ss
outplans10259533outplans
outports1048273outports
outprays13236933outprays
outraces102217863outraces
outrages92215933outrages
outran63218893outra_n_
outrang83813953outra_ng
outrank112611973outra_nk
outranks12298823outranks
outrates82421373outrates
outraves112313833outraves
outreads9289003outrea_ds
outreasons1053073outreasons
outroars838923outroar_s
outruns72911543out_runs
outsails8139863outsails
outsang83411273outsa_ng
outsays102710403outsa_ys
outscorns11144883outscorns
outserts8309803outserts
outsins73417863out_sins
outsmarts11155143outsmarts
outsoars838853outsoar_s
outspans1038223outspans
outstares91610183outstares
outstarts9176323outstarts
outswears1244303outswear_s
outtakes12310033outtakes
outtalks1236503outtalks
outtasks1235633outtasks
outturn737123outturn_
outvaunt1145133outvaunt
outvaunts1242743outvaunts
outwaits1137493outwaits
outwalks1535993outwalks
outwar91011513outwar__
outward11811403outwar_d
outwear1097713outwear__
outwearies1345353outwearies
outwearing1437183outwearing
outweary1485393outwear_y
outworks15148973outworks
outworn101610753outworn_
oxhearts1842903oxhearts
oxters134813273oxte_r_s
posterns102713723poste_rns
pouters94221873poute_r_s
queans153110753qu_ea_ns
querns15307943qu_e_rns
reearns749103_reearns
relearns836303relearns
retears72814923retear_s
routers74822873route_r_s
souters74422603soute_r_s
southerns12347213southerns
stearins8312143_stearins
sterns64616763_ste_rns
tarns56433953__t_arns
tears55436463__tear_s
terns55226873__te_rns
touters74018353toute_r_s
tutelars844993tutelar_s
unlearns844453unlearns
uptears9106453uptear_s
uterus639203_ute_rus
veterans1148853veterans
yearns9509543__yearns

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621676.40622816.4
3Display Results1671670.0632650.8
 (SQL Overall)1786911676.87525991.4
 
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.