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

67 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
odahs9561008(None) 
dahs88231811_dahs
odah87018931odah_
odas57230261oda_s
opahs105411981opahs
aahs716428562_aahs
ahs68644822__ahs
amahs107819062amahs
ayahs116813522ayahs
blahs105616512blahs
codas84724242coda_s
dabs77139402_dabs
dads67442772_dads
dags66642592_dags
dah78148982_dah_
dahl87019222_dahl
dahls95012282_dahls
dais57040702_dais
daks97130602_daks
dals57145122_dals
dams77444372_dams
dans56748142_dans
daps77239162_daps
dash87031632_dash
daws86638242_daws
days87637132_days
doats65224882doats
edhs86212102ed_hs
hahs108333362_hahs
hodads1147962hodads
horahs126313872horahs
houdahs1434242houdahs
howdahs1733612howdahs
lotahs9479872lotahs
modals93914442modals
oafs76425262o_afs
oaks86527902o_aks
oars46846032o_ars
oaths86117312oaths
oats46554212o_ats
obas65730932oba_s
obeahs1135862obeahs
ocas66729632oca_s
oda48133042oda__
odds68919922od_ds
odes57243242od_es
odors64514272odors
ods47546212od__s
odyls9428652odyls
ofays11488922ofays
ogams84112682ogams
ohs66232312o__hs
okas85225392oka_s
okays12609442okays
okehs12477462okehs
oohs75220692o_ohs
opah96218402opah_
opals75718352opals
orals55826482orals
ouphs104311272ouphs
ovals85413392ovals
shahs115919512shahs
sodas64123542soda_s
todays10458102todays
torahs95115642torahs
yeahs115214552yeahs
yodhs12669012yod_hs

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.0961861364.6
2DLD Change Limit53800671.84329191.5
3Display Results67670.0135153.8
 (SQL Overall)178691671.95291542.5
 
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.