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

143 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
handout1131410(None) 
handouts1238231handouts
hangout11411391hangout
candour104210232candour
handful14127252handful
handgun1244622handgun
handoff1756482handoff
handset113016822handset
hangouts1236182hangouts
hindgut1245012hindgut
holdout11510892holdout
pandour10408212pandour
standout948662standout
about75229083_a_bout
adnoun757033_adnoun
adopt81219743_a_dopt
ardour74110893_ardour
backout15612953backout
bailout9414133bailout
bandit93821133band_it
bandog1038723bando_g
bandogs1138363bandogs
bandora1038813bandora
bandore10611633bandore
campout13412853campout
candent10417363candent
candor94516423cando_r
candors104216763candors
candours11408613candours
cannot83616773canno_t
fadeout11410193fadeout
fallout10313503fallout
fandom122110893fando_m
fandoms13229473fandoms
fanwort13310733fanwort
foldout1149523foldout
hackbut1845713hackbut
haddest122711993haddest
haddock1885583haddock
hadst93220223ha_d_st
hagbut1278913ha_gbut
hagdon1188283hagdo_n
hagdons1258523hagdons
haircut1246833haircut
halibut1289053halibut
hallot95426783hallo_t
hand86833703hand___
handax1749583hand_ax
handbag1495863handbag
handbook1844733handbook
handcar1337373handcar
handcart1449323handcart
handcuff2042553handcuff
handed114919983hand_ed
hander104526433hand_er
handers114224333handers
handfast1546733handfast
handfuls15115753handfuls
handguns1344363handguns
handhold1645633handhold
handier113817443handier
handiest123417773handiest
handily143610873handily
handing123518893handing
handle104219293hand_le
handled124114533handled
handler113516163handler
handles114020653handles
handlist12311333handlist
handloom1444613handloom
handoffs1844733handoffs
handover15126823handover
hands95327383hand__s
handsaw1435533handsaw
handsel11308723handsel
handsets12258343handsets
handsful1544083handsful
handsome1447603handsome
handwork1946903handwork
handwrit1547243handwrit
handy125520873hand__y
hangdog1343133hangdo_g
hangdogs1443603hangdogs
hangul1049213han_gul
hangup1277293han_gup
hansom11219153hanso_m
hansoms12238523hansoms
hant75461583han___t
haplont12412563haplont
harbour1247053harbour
hardboot1446943hardboot
hardcourt1544043hardcourt
hardest113118413hardest
hardhat14411023hardhat
hardset113415833hardset
harlot94422803harlo_t
haut75949733ha___ut
haviour1354823haviour
hayloft1696963hayloft
hideout1179793hideout
hindguts1343013hindguts
hindmost1444473hindmost
holdouts1245473holdouts
honour94710863hon_our
hornpout1356703hornpout
knout95018263_kn_out
landau7310613landau_
landaus8310343landaus
layout9513703la_yout
mahout11415803ma_hout
mandola1039023mandola
padouk1336683pa_douk
pandect12310953pandect
pandit93820753pand_it
pandoor10358583pandoor
pandora1039543pandora
pandore10411853pandore
pandours11317983pandours
pantoum1138703pantoum
payout11714653pa_yout
phaseout1346783phaseout
ragout7317183ra_gout
rainout7314393rainout
rancour987133rancour
random92513553rando_m
randoms102112433randoms
readout8615493readout
redout71820253_redout
runout6414873run_out
sandbur10105353sandbur
sandlot8311693sandlot
sandpit1049633sandpit
sandwort12410073sandwort
sanious7514103sanious
santour737373santour
shakeout1546613shakeout
snout54530633_sn_out
standouts1044983standouts
takeout1149873takeout
tandoor8278563tandoor
vanadous1246023vanadous
walkout1447933walkout
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.236757165.3
2DLD Change Limit1340271437.48317910.9
3Display Results1431430.0463108.7
 (SQL Overall)1786911437.76523012.4
 
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.