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

116 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
hangout1141139(None) 
handout11314101handout
hangouts1236181hangouts
hagbut1278922ha_gbut
handouts1238232handouts
hangul1049212hang_ul
hangup1277292hang_up
ragout7317182ra_gout
about75229083_a_bout
agouti7388773_a_gouti
agouty10366913_a_gouty
angora71111573_angora
angst6415493_ang_st
argot67728653_argo_t
backout15612953backout
bailout9414133bailout
bugout9311863_bugout
burgout1049773burgout
campout13412853campout
candour104210243candour
cangue91012443cang_ue
cannot83616773canno_t
catgut9310803catg_ut
changeup1642683changeup
clangour11293803clangour
congou94313243congou_
congous103615083congous
dugout8310363_dugout
englut738453_englut
fadeout11410193fadeout
faggot1139053faggo_t
fagot9323403fa_go_t
fallout10313503fallout
fanwort13310733fanwort
fungous11367433fungous
gangue81310573gang_ue
gout56646003___gout
hackbut1845713hackbut
hagbuts1354933ha_gbuts
haircut1246833haircut
halibut1289053halibut
hallot95426783hallo_t
handful14127253handful
handgun1244623handgun
handoff1756483handoff
handset113016823handset
hang85535553hang___
hangar104114513hang_ar
hangars114313493hangars
hangdog1343133hangdog
hangdogs1443603hangdogs
hanged114222393hang_ed
hanger104023253hang_er
hangers113120813hangers
hanging123518703hanging
hangman1337813hangman
hangmen1337383hangmen
hangnest12311413hangnest
hangover15134433hangover
hangs95726723hang__s
hangtag1244533hangtag
hangups1364813hangups
hansom11219153hanso_m
hansoms12238523hansoms
hant75461593han___t
haplont12412563haplont
harbour1247053harbour
harlot94422803harlo_t
haut75949733ha___ut
haviour1354823haviour
hayloft1696963hayloft
hideout1179793hideout
hindgut1245013hindgut
hognut1039413h_ognut
holdout11510903holdout
honour94710863hon_our
hornpout1356703hornpout
ingot61221063_ingo_t
knout95018263_kn_out
langouste1043513langouste
langue71012173lang_ue
languet8713693languet
languor895423languor
langur7109303lang_ur
layout9513703la_yout
maggot10311713maggo_t
magot8326393ma_go_t
mahout11415813ma_hout
mango85724323mango__
mangoes104316133mangoes
mangold1137213mangold
mangos94319333mango_s
pandour10408213pandour
pantoum1138703pantoum
payout11714653pa_yout
phaseout1346783phaseout
pigout9314613_pigout
ragouts838543ra_gouts
rainout7314393rainout
rancour987133rancour
runout6414873run_out
sagbut959753sa_gbut
sanious7514103sanious
santour737373santour
shakeout1546613shakeout
snout54530633_sn_out
standout948663standout
takeout1149873takeout
tangent8314993tangent
tango66921173tango__
tangoed9318833tangoed
tangos74216303tango_s
ungot61718063_ungo_t
walkout1447933walkout
wangun1037103wang_un
washout13410133washout

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340271166.57620381.2
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.02825425.6
 
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.