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

52 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
haunters1132953(None) 
chaunters1455811chaunters
daunters9329841daunters
haunter103111151haunter_
hunters103915721h_unters
saunters82911741saunters
taunters8259261taunters
vaunters11327741vaunters
banters94623112ba_nters
bunters94717112_bunters
canters94827722ca_nters
chanters134016722cha_nters
chaunter1366382chaunter_
chunters133910892chunters
counters103320182counters
daunders10278472daunders
daunter83811752daunter_
fainters11349692fainters
flaunters1234502flaunters
gaunter82910712gaunter_
grunters9359022grunters
hafters134614332ha_fters
halters104619802ha_lters
hamsters13710422hamsters
handers114224332ha_nders
hangers113120812ha_ngers
hankers144218132ha_nkers
haters94930392ha__ters
hatters104221522ha_tters
haulers104012442hau_lers
hauliers1176712hauliers
haunted11399732haunte_d
haunts95614392haunt__s
hauteurs1133732hau_teurs
hinters103719572h_inters
hounders123111702hounders
hungers114013302h_ungers
hunkers143314332h_unkers
hunter94817772h_unter_
hurters103413632h_urters
launders9358742launders
maunders11348342maunders
mounters103712492mounters
painters103013022painters
punters93617032_punters
ranters73323642ra_nters
saunter72913452saunter_
shunters113210732shunters
taunter73111452taunter_
vaulters11206162vaulters
vaunter10309602vaunter_
wanters104420092wa_nters

Search took 5 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 Filter1786911210590.1561145455.1
2DLD Change Limit121059524.31328068.4
3Display Results52520.0163250.0
 (SQL Overall)178691524.48539841.9
 
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.