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

113 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
milding11361545(None) 
gilding103813001gilding
hilding123713531hilding
melding113414271melding
milking143712761milking
milling103223681milling
milting103619121milting
minding113317891minding
molding114213751molding
wilding123814291wilding
aiding84423612ai_ding
ailing74331012ail_ing
balding114015062balding
bidding123613502bidding
biding104720792bi_ding
bielding12237472bielding
bilging114212682bilging
bilking144413552bilking
billing103823852billing
binding113819382binding
birding114014922birding
building1237502building
childing15288502childing
eliding93414342eliding
fielding13206862fielding
filing103823762fil_ing
filling113520802filling
filming133210352filming
finding124116542finding
folding123912442folding
gelding103911792gelding
gildings11356962gildings
gilling93520382gilling
girding103611882girding
gliding103911842gliding
hiding114319332hi_ding
hildings13347492hildings
hilling113821772hilling
hilting113316892hilting
holding123514282holding
idling8912882_idling
jilting153211742jilting
kidding14389762kidding
killing123118722killing
kilning12289022kilning
kilting123213852kilting
lidding103611422lidding
lilting83515382lilting
madding123711992madding
mailing102923342mail_ing
malling103623662malling
malting103219082malting
melling102822622melling
melting103317752melting
mending114018682mending
miching152911802miching
middling13249332middling
midline102315102midline
miffing16298402miffing
miking134218462mi_king
milden94113152milden_
mildening1345662mildening
mildens10339932mildens
mildewing1643722mildewing
milline92519112milline
millings113712582millings
miming114317262mi_ming
mincing123314332mincing
mining94225452mi_ning
minting103020812minting
miring93723802mi_ring
misdoing1238802misdoing
mislying1437842mislying
missing103619072missing
misting103623382misting
mitring103514142mitring
mixing164713942mi_xing
moiling103417662moil_ing
moldings12267202moldings
molting103517172molting
moulding12258142moulding
mudding123310812mudding
muling93519882mul_ing
mulling103819992mulling
niding83217972ni_ding
nilling83619562nilling
oiling74925312oil_ing
piling95025592pil_ing
pilling103722562pilling
ridding103314182ridding
riding84325962ri_ding
riling74227972ril_ing
rilling84023622rilling
siding83822132si_ding
sidling9915422sidling
silking123715592silking
siloing83215492siloing
silting83320482silting
sliding93114552sliding
smiling103915442smil_ing
tiding83520092ti_ding
tiling73426552til_ing
tilling83522772tilling
tilting83417102tilting
welding123213252welding
wielding13286862wielding
wildings13287922wildings
wildling13248082wildling
wiling103024292wil_ing
willing113821612willing
wilting113515912wilting
winding123517912winding
yielding13205032yielding

Search took 4 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.1231452772.4
2DLD Change Limit1076711132.92336835.8
3Display Results1131130.0462456.5
 (SQL Overall)1786911133.09257791.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.