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

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

46 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
redissolves155196(None) 
redissolve1452121redissolve_
redissolved1651841redissolved
dissolves1346232__dissolves
dissolve1246103__dissolve_
dissolved1445593__dissolved
dissolver1345623__dissolver
dissolvers1444643__dissolvers
rediscover1653163redisco_ver
rediscovers1752413redisco_vers
redisposes1344843redispo_ses
redissolving1751433redissolving
reinvolves1642773re_involves
resolves113010783re___solves
rissoles839113r__issol_es
undissolved1651403undissolved
dissaves1239414__diss_aves
disserves1388064__disserves
dissolvent1454574__dissolvent
dissolvents1553114__dissolvents
predisposes1653454predispo_ses
presolves1456534pre___solves
radiosondes1352594radiosondes
recessives1545674recess_ives
reconsoles1245144reconsol_es
redingotes1243394redingo_tes
rediscounts1452284rediscounts
rediscovery2051934redisco_very
rediscusses1452254rediscusses
redisplays1651594redi_splays
redispose1244674redispo_se_
redisposed1443914redispo_sed
redistilled1352804redistilled
redistills1143164redistil_ls
redivorces1642964redi_vorces
reinvolve1542764re_involve_
reinvolved1752564re_involved
reissues845994re_iss__ues
remissive1445774remiss_ive_
resoles73823654re___sol_es
resolve103910984re___solve_
resolved12349344re___solved
resolver11339794re___solver
resolvers12297834re___solvers
revolves14278624re___volves
rissole739784r__issol_e_

Search took 9 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 Filter1786911488190.1561145455.1
2DLD Change Limit148819468.40617703.9
3Display Results46460.0162875.0
 (SQL Overall)178691468.57820831.3
 
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.