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

88 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
granter8411713(None) 
grafter114211151grafter
grander93315871grander
granger93514211granger
granted94715101granted
grantee83217131grantee
granters93614141granters
grantor84010931grantor
grater74625441gra_ter
grunter83110781grunter
ranter63826821_ranter
banter84825332_banter
brander103915822brander
branner94212372branner
canter85230112_canter
chanter123919732chanter
crafter124111332crafter
cranker133612782cranker
crater85026642cra_ter
drafter11449422drafter
franker143510182franker
frater94520592fra_ter
fronter103611582fronter
gaiter73819502g_aiter
gander84322762g_ander
ganger83721462g_anger
garner73917002garn_er
garter74420512g_arter
gaster75027352g_aster
gater64533652g_a_ter
gaunter82910712gaunter
glancer103710072glancer
grabber12389762grabber
grader84919692gra_der
grafted124110222grafted
grafters12409192grafters
grainer83714062grainer
grainier9218902grainier
grandee93115512grandee
grandeur10305672grandeur
grange83716202grange_
grangers103011972grangers
granges93516522granges
granite82017082granite_
granites92116362granites
grant64840022grant__
grantees92510972grantees
grantors93810352grantors
grants73722472grant_s
grapier103712602grapier
grasper10389792grasper
grate64932882gra_te_
grated84523922gra_ted
graters85419742gra_ters
grates75429892gra_tes
graver105018592gra_ver
grayer106014542gra_yer
grazer164815762gra_zer
grazier173611132grazier
greater84416492greater
greeter82812672greeter
grifter113810492grifter
grinder93312392grinder
grinner8329232grinner
grister83915412grister
gritter83913352gritter
groaner82510132groan_er
grouter84412522grouter
grunger9389782grunger
grunted9339282grunted
grunters9359032grunters
irater65218352ira_ter
krater104014312kra_ter
planter94017802planter
prancer113613382prancer
prater84825352pra_ter
printer93917302printer
rafter94517582_rafter
ranger73925522_ranger
ranker105021902_ranker
ranted74324702_ranted
ranters73323642_ranters
raster64731442_raster
rater54943282_ra_ter
ratter64326312_ratter
renter64527412_renter
scanter94215182scanter
wanter94423052_wanter

Search took 4 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 Filter1786911076710.186960704.3
2DLD Change Limit107671882.90637051.3
3Display Results88880.0302933.3
 (SQL Overall)178691883.12257236.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.