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

76 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
regosol84488(None) 
regosols944321regosols
aerosol747682aerosol
creosol946042cre_osol
reposal939112reposal
retool63914482reto_ol
aerosols847213aerosols
befool1137713befo_ol
creosols1045713cre_osols
cresol8310203cre__sol
cytosol1244543cytosol
deposal1037153deposal
dewool1047403dewo_ol
egos55821653_egos__
girosol885303girosol
gregos847533gregos__
latosol745283latosol
precool1139013preco_ol
reason62616333re_ason
reboil83814683rebo_il
rebook125213203rebo_ok
reboot84119333rebo_ot
rebozo1737323rebozo_
rebozos1835143rebozos
recoal84117973reco_al
recoil84016723reco_il
recolor978693recolor
reconsole1145693reconsole
recook125513923reco_ok
recusal968673recusal
redos65126763redos__
refusal1056893refusal
regal65023793reg__al
reges65628783reges__
reginal84814293reginal
region74614903reg_ion
regional9438783regional
regloss8218023reglos_s
reglow10339403reg_low
regnal74812933reg_nal
regorge9257833regorge
regroom1077293regroom
regrow10309883reg_row
regs55436573reg_s__
relook104813743relo_ok
remodel1038093remodel
removal1236733removal
reoil55321183re_o_il
repoll8410793repo_ll
repos74725793repos__
reposals1037403reposals
repose84121413repos_e
reposed103616273reposed
reposer93715333reposer
reposes94021263reposes
reposit9315863reposit
reroll6412683rero_ll
reroof9315003rero_of
rerose63320843reros_e
resod64720053re__sod
resold73915363re__sold
resole64624183re__sole
resow88217243re__sow
respool937633respool
retinol7469693retinol
retook104313443reto_ok
retools73411023reto_ols
retotal739843retotal
revisal1038263revisal
revisor10388733revisor
rugosa734563rugos_a
rugosas844973rugosas
rugose737283rugos_e
rugosely1242333rugosely
segos64919483segos__
serosal7311143serosal

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 Filter1786911340270.1561145455.1
2DLD Change Limit134027768.51315743.8
3Display Results76760.0332303.0
 (SQL Overall)178691768.70220534.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.