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

85 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
arising8361997(None) 
irising83614421irising
prising103321451prising
raising83220531raising
rising74025881_rising
abasing10610672abasing
abiding11510502abiding
abusing1049112abusing
advising1336152advising
agisting1038242agisting
aiding84423612a_iding
ailing74331012a_iling
aiming94320842a_iming
airing74927502a_iring
airting83616302airting
aliasing9310072aliasing
alining81917042alining
amusing1039382amusing
apprising1447962apprising
arching136216692arching
arcing95819642ar_cing
arcking145811962arcking
arcsine94512392arcsine
argling92812732argling
arguing9248732arguing
arisen65316792arisen_
arming94719802ar_ming
arousing93811802arousing
arriving1237362arriving
arsine64021042ar_sine
arsino64113512ar_sino
braising113014562braising
bribing123111042bribing
brining103216472brining
brisking15329472brisking
brisling112410842brisling
bruising11279142bruising
crisping13319662crisping
cruising112610152cruising
driving123910712driving
erasing8317962erasing
frisking16268362frisking
frizing203310872frizing
griding103014972griding
griming113612492griming
griping113012062griping
guising93511412guising
hoising113414412hoising
noising83615172noising
parsing103819552par_sing
peising103416762peising
poising103617102poising
praising113214562praising
pricing123417342pricing
priding113317542priding
priming123417372priming
prissing113011452prissing
prizing193514682prizing
prosing103319382prosing
raiding93617592raiding
railing83325642railing
raining83922692raining
raisin62716922raisin_
raisings9338442raisings
raisins72715342raisins
raisiny10319922raisiny
rasing74330832_rasing
rerising93017782rerising
ricing94822762_ricing
riding84325962_riding
riling74227972_riling
riming93322222_riming
rinsing82516112_rinsing
riping93821612_riping
risings83211892_risings
risking123914242_risking
riving104521422_riving
rosing73925592_rosing
seising84018862seising
tricing103417352tricing
trining82919212trining
uprising1138952uprising
vising103915872_vising
wising103318222_wising
writing113713892writing

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.373479064.3
2DLD Change Limit107671853.48330913.3
3Display Results85850.0332575.8
 (SQL Overall)178691853.88945947.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.