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

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

96 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
haafs11571116(None) 
haaf106227731haaf_
haars85620471haars
aahs716428562_aahs
aals49941142_aals
aas310975392_aa_s
arfs76029962_arfs
baals76122702baals
baas66844672baa_s
baffs134718052baffs
barfs104826002barfs
caffs135417372caffs
calfs104919382calfs
chaffs17459612chaffs
daffs125116422daffs
gaffs124914652gaffs
haar77323492haa_r
habus106317142habus
hacks144928712hacks
hades96035112hades
haems105517012haems
haes77651022h_aes
haets86525122haets
haft105941842h_aft
hafts116219462hafts
hags86740842h_ags
hahas117118442hahas
hahs108333362h_ahs
haiks125120932haiks
hails85231642hails
hairs86225172hairs
hajes155420942hajes
hajis156716282hajis
hakes126034302hakes
hakus125114112hakus
halals95018312halals
hales85449842hales
half106238452half_
halls85633782halls
halms105225212halms
halos85230252halos
halts85230102halts
hamals114816822hamals
hames106138702hames
hams96446132h_ams
hands95327382hands
hangs95726722hangs
hanks126226862hanks
hants86335402hants
haps96443462h_aps
harass9313942harass
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
has67372652h_a_s
hasps105114642hasps
hates86742572hates
hats76858252h_ats
hauls86123732hauls
haves116034872haves
hawks155415702hawks
haws106439442h_aws
hays106138072h_ays
hazans183411652hazans
hazes174928322hazes
heads95127112heads
heals85733452heals
heaps105223222heaps
hears86737372hears
heats85838402heats
hoars85925552hoars
hoofs115721042hoofs
howfs144814502howfs
huffs144514742huffs
kaas86531842kaa_s
kafs116423742_kafs
kaifs125715642kaifs
khafs15648842khafs
leafs85721182leafs
loafs85616992loafs
maars74621632maars
naans55815252naans
naffs116213962naffs
naifs87617422naifs
oafs76425262_oafs
raffs115017522raffs
sheafs124912882sheafs
waffs146315472waffs
waifs115719872waifs
wharfs1546372wharfs
yaffs145311122yaffs
zarfs174713622zarfs

Search took 2 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 Filter178691538000.313570897.8
2DLD Change Limit53800961.42037887.3
3Display Results96960.0303200.0
 (SQL Overall)178691961.763101356.2
 
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.