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

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

84 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
antihunting157393(None) 
antiquating2146432antiquating
anointing1038623anoi__nting
antibusing1345363antibu_sing
antidoting1247163anti_doting
antidumping1752093antidumping
antihunter1353863antihunt_er
antiquing1947303antiqu__ing
nonhunting1444683_nonhunting
outhunting1446143out_hunting
pothunting1643653pot_hunting
accounting1544924a_ccounting
activating1647864acti_vating
actuating1239234act__uating
alimenting1344504a_limenting
amounting1236644a__mounting
animating12312514an_i_mating
annihilating1653084annihilating
announcing1342994an_nouncing
antedating1277554ant_edating
anteverting1544334anteverting
antheming1587294ant_h_eming
antiaging1149674anti__aging
antiauxin1645084antiau_xin_
antiauxins1755044antiau_xins
anticaking1747604anti_caking
anticipating1756264anticipating
anticking1649244anti__cking
anticling12310694anti__cling
anticlotting15113014anticlotting
antifoaming1754114antifoaming
antifogging1752694antifogging
antifouling1553624antifouling
antiheroine1455304antiheroine
antihuman1445374antihu_man_
antijamming2352264antijamming
antiking13412074anti___king
antilynching2161294antilynching
antiquation2047424antiquation
antiquations2146244antiquations
antiquities2056624antiquities
antismoking1853694antismoking
antispending1652574antispending
antiunion986384anti_un_ion
antivenin1247024antiven_in_
antivenins1346774antiven_ins
antiwhaling1853204antiwhaling
arointing1049364aroi__nting
articulating1556764articulating
astounding1244154ast_ounding
attainting1144784a_ttainting
attenuating1253104attenuating
attributing1453134attribu_ting
attuning935904a_t_tun_ing
cantillating1565054cantillating
enchanting1645944en_chanting
enthusing1355214ent_hu_sing
entrusting11126184ent_rusting
foxhunting2441834_foxhunting
headhunting1951794headhunting
hunting114317124____hunting
insinuating1244534insinuating
instituting1244804institu_ting
intimating13410824inti_mating
intituling1144444intitu_ling
intrusting11128174int_rusting
intuiting1089614int__uiting
outcounting1444304outcounting
outstunting1243784outstunting
outvaunting1542894outvaunting
overhunting1856524overhunting
pothuntings1751594pot_huntings
retinting102215254reti__nting
shunting123610434___shunting
stinting93415744_sti__nting
strunting1037874_st_runting
stunting92811504_st__unting
taunting93510934__t_aunting
thunking16196954__t_hunking
tinting84620604__ti__nting
unstinting1147304unsti__nting
unthinking1844664unt_hinking
untrusting1186004unt_rusting
untuning937944unt__un_ing

Search took 10 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 Filter1786911488190.423422437.4
2DLD Change Limit148819849.07616397.0
3Display Results84840.0461826.1
 (SQL Overall)178691849.54518720.9
 
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.