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

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

77 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
ardour74110891ardour_
ardours8368871ardours
arbour84211322arbour_
arbours93910032arbours
ardor64617862ardo_r_
ardors74416862ardo_rs
armour84411852armour_
armours9389842armours
armoury12376232armoury
hardcourt1544042hardcourt
abduct11108543abd_uct
abort76133583a_bo_rt
about75229083a_bou_t
account11109043account
adduct1087373a_dduct
adjourn1563423adjourn
adjure1435833a_djure
adjust1447173a_djust
adopt81219743a_do_pt
adore65723663a_do_re
adorn64917093a_do_rn
adroit7518783adro_it
adult63520653a_d_ult
adust64117453a_d_ust
advert103215773a_dvert
aeroduct1155633aeroduct
airport9511383airpo_rt
amort75832203a_mo_rt
amount8414483a_mount
amour75014853a_mour_
amours83512643a_mours
aport75432173a_po_rt
arbor74818113arbo_r_
arbors84717873arbo_rs
arboured1156253arboured
ardent73022613ard_ent
arduous837603arduous
argot67728643argo__t
armoire938133armoire
armor75118053armo_r_
armors85017813armo_rs
armory114211473armo_ry
armoured1165223armoured
armourer1054883armourer
armure8710133ar_mure
aroint6328153ar_oint
around72712413ar_ound
arouse65019983ar_ouse
aroynt9312893ar_oynt
assort64916373asso_rt
candour104210233candour_
candours11408613candours
carport11316033carpo_rt
court75532763__court
doubt8720093__doubt
dour56330433__dour_
doura66518663__doura
grout65330423gr_ou_t
handout11314103handou_t
harbour1247053harbour_
harbours1346903harbours
odour64710473_odour_
odours7418233_odours
ordure756803ord_ure
pandour10408213pandour_
pandours11317983pandours
parlour937263parlour_
parlours1036153parlours
product1279233product
ragout7317183ragou_t
redoubt10167843redoubt
redout71820253redou_t
roust55532063_r_oust
rout46153283_r_ou_t
trout57332573tr_ou_t
tryout9410753tryou_t
upcourt1146103upcourt

Search took 8 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 Filter1786911340270.1531167915.0
2DLD Change Limit134027776.92319359.7
3Display Results77770.0164812.5
 (SQL Overall)178691777.09225196.1
 
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.