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 “hilding” with Change Limit: [1] [2]

(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
hilding12371353(None) 
childing15288501childing
gilding103813001gilding
hiding114319331hi_ding
hildings13347491hildings
hilling113821771hilling
hilting113316891hilting
holding123514281holding
milding113615451milding
wilding123814291wilding
aiding84423612ai_ding
ailing74331012ail_ing
balding114015062balding
bidding123613502bidding
biding104720792bi_ding
bielding12237472bielding
bilging114212682bilging
bilking144413552bilking
billing103823852billing
binding113819382binding
birding114014922birding
building1237502building
chiding143911592chi_ding
chilling143512182chilling
eliding93414342eliding
fielding13206862fielding
filing103823762fil_ing
filling113520802filling
filming133210352filming
finding124116542finding
folding123912442folding
gelding103911792gelding
gildings11356962gildings
gilling93520382gilling
girding103611882girding
gliding103911842gliding
hading113922942h_ading
hailing113820692hail_ing
haling104229782hal_ing
haloing113814132haloing
halting114419072halting
halving143511542halving
handing123518892handing
heading122919112heading
heeding123515062heeding
heiling113616362heil_ing
helling114623222helling
helming133712002helming
helping133512222helping
helving144011132helving
herding122915122herding
hidings12349692hi_dings
hieing104216622hi_eing
hiking143617102hi_king
hilloing12158292hilloing
hinging123917102hinging
hinting113919222hinting
hipping153915102hipping
hiring104421602hi_ring
hissing114213142hissing
histing113720372histing
hitting113017272hitting
hiving134115522hi_ving
holdings13297742holdings
holing104025072hol_ing
holking153512312holking
hooding123815202hooding
hording123517052hording
hulking153910982hulking
hulling113619012hulling
idling8912882_idling
jilting153211742jilting
kidding14389762kidding
killing123118722killing
kilning12289022kilning
kilting123213852kilting
lidding103611422lidding
lilting83515382lilting
melding113414272melding
milking143712762milking
milling103223682milling
milting103619122milting
minding113317892minding
molding114213752molding
niding83217972ni_ding
nilling83619562nilling
oiling74925312oil_ing
piling95025592pil_ing
pilling103722562pilling
ridding103314182ridding
riding84325962ri_ding
riling74227972ril_ing
rilling84023622rilling
shielding1434552shielding
shilling123315372shilling
siding83822132si_ding
sidling9915422sidling
silking123715592silking
siloing83215492siloing
silting83320482silting
sliding93114552sliding
tiding83520092ti_ding
tiling73426552til_ing
tilling83522772tilling
tilting83417102tilting
welding123213252welding
whidding1734572whidding
whiling143511742whil_ing
wielding13286862wielding
wildings13287922wildings
wildling13248082wildling
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winding123517912winding
yielding13205032yielding

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 Filter1786911076710.1261418182.5
2DLD Change Limit1076711165.90618230.8
3Display Results1161160.0761526.3
 (SQL Overall)1786911166.10829255.2
 
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.