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

64 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
absolve124451(None) 
absolved1443131absolved
absolver1343691absolver
absolves1344411absolves
above105414322ab_o_ve
absolute1044482absolute
absolvent1454102absolvent
absolvers1443132absolvers
resolve103910982resolve
solve85618942__solve
abalone938903abalone
abele76323253ab_el_e
able66340533ab__l_e
abode85518813ab_o_de
abolla8410193ab_olla
abollae936943abollae
aboves114512843ab_o_ves
abscise1145953abscise
absence1137703absence
absoluter1142923absoluter
absolutes1144523absolutes
absolutive1552653absolutive
absolvents1562973absolvents
absolving1543323absolving
absorb1038013abso_rb
absorbed1344263absorbed
absorber1254313absorber
absorbs1135613absorbs
abusive1245283abusive
abvolt11169833abvol_t
abvolts12104373abvolts
aisle55223193ais_l_e
alcove1178083alco_ve
amole75724593a_mol_e
anisole71010833anisol_e
anole55330373a_nol_e
areolae7811733areolae
areole61017283areol_e
aslope839013a_slope
asshole1046793asshol_e
azole145118033a_zol_e
bole66448693_b_ol_e
devolve14316063devolve
dissolve1246103dissolve
evolve12306503_evolve
insole63515863insol_e
involve1345093involve
obole75917143ob_ol_e
observe1245323observe
obsolete1044313obsolete
posole8314223posol_e
presolve1347073presolve
resole64624183resol_e
resolved12349343resolved
resolver11339793resolver
resolves113010783resolves
revolve13328373revolve
salve85022133__salve
soave84219053__soave
sole46053673__sol_e
solved105312933__solved
solver94016703__solver
solves95018223__solves
unsolved1237833unsolved

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.1561145455.1
2DLD Change Limit134027647.29618369.9
3Display Results64640.0302133.3
 (SQL Overall)178691647.48223882.8
 
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.