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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

184 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
arointing104936(None) 
anointing1038621anointing
aroynting1344631aroynting
amounting1236642amounting
appointing1545322appointing
fronting12310442fro_nting
groining102310632groin_ing
jointing16248612_jointing
pointing112813682_pointing
printing113216082pr_inting
abominating1644843abominating
aborning1188003aborn_ing
aborting11710253abo_rting
abounding1335193abounding
abrogating1497983abrogating
absenting1236993absenting
accenting1487823accenting
accounting1544923accounting
addicting1485073addicting
adjoining1844033adjoin_ing
admitting1345033admitting
adopting1237453ado_pting
adorning1087323adorn_ing
affronting1742603affro_nting
agenting1039383a_genting
agisting1038243a_gisting
agonising1146573agonising
agonizing2047143agonizing
airlifting1443343airlifting
airting83616303a__irting
alining81917043a_lin_ing
anting75827023a___nting
aproning11311793apro_n_ing
argentine1047893argentine
arginine948563argin_ine
arising83619973ar_i_sing
aroint6328153aroint___
arointed939003aroint_ed
aroints7313133aroint__s
arousing93811803aro_using
arranging1156303arranging
arresting1038633arresting
arriving1237363arri_ving
arrogating121778393arrogating
articling1247713articling
assenting1038163assenting
assisting1046183assisting
atoning83514873ato_n_ing
attainting1144783attainting
auditing1039033audi_ting
aviating12311023a_viating
avoiding1336783avoi_ding
awaiting1238273awai_ting
boinking15378423_boinking
braining113414683brain_ing
bringing123011273br_inging
brining103216473br_in_ing
broiling113112013broi_ling
bromating1439183bromating
brominating1696093brominating
bronzing2037693bro_nzing
browning14299643brown_ing
bruiting11259973brui_ting
coining103920553_coin_ing
counting113115273_counting
cringing123311383cr_inging
crooning113112113croon_ing
crowning143510033crown_ing
dinting93520553__dinting
draining103312673drain_ing
drifting13338733dr_ifting
drinking14308913dr_inking
droning93013723dro_n_ing
drownding1564123drownding
drowning13298363drown_ing
eloining9310443eloin_ing
fainting123312163_fainting
feinting123410833_feinting
flinting123412343_flinting
foining113013453_foin_ing
foisting122910503_foisting
fringing133010903fr_inging
fritting123510703fr_itting
frosting12311183fro_sting
frouncing1534763frouncing
frowning15307833frown_ing
frowsting1634683frowsting
fruiting12229063frui_ting
garmenting1445493garmenting
garoting10510703garo__ting
garotting1136113garo_tting
glinting103210053_glinting
graining102813183grain_ing
granting103514523gr_anting
grifting13299263gr_ifting
grinding1139863gr_inding
grinning1037863gr_inning
gritting10309983gr_itting
groaning102410283groan_ing
grounding1236083grounding
grouting103410793gro_uting
grunting10269583gr_unting
hinting113919223__hinting
hoisting123610903_hoisting
ironing82414013iro_n_ing
ironizing1947933ironizing
joining153011483_join_ing
joisting16328503_joisting
lariating10311793lar_iating
linting83820983__linting
margenting1446153margenting
marginating1545893marginating
margining1337603margin_ing
marinating13410273mar_inating
marooning1238593maroon_ing
minting103020813__minting
mounting112711813_mounting
oinking123714713__oinking
orbiting1138153orbi_ting
orienting1038723orienting
painting113614423_painting
parenting12611583par_enting
poinding122510003_poinding
prinking153212453pr_inking
printings12268113pr_intings
probating14311193probating
profiting1549983profiting
promoting1439923promoting
prompting1637203prompting
pronating12313763pronating
pronging123511843pro_nging
propining14310133propin_ing
prorating12314283prorating
quoining1835893quoin_ing
quoiting1836093quoi_ting
radiating111112133radiating
raining83922693_rain_ing
ranting84025413_r_anting
ravining12269693ravin_ing
reanointing1244993reanointing
reining84425323_rein_ing
reinking13311023_reinking
reminting122315103reminting
renting84026853_r_enting
retinting102215253retinting
rifting113515003_r_ifting
ringing93521283_r_inging
rinning83216743_r_inning
rinsing82516113_r_insing
rioting82716393_r_ioting
roasting93012703_roasting
roiling83220453_roi_ling
roosting93411463_roosting
rooting83522433_ro_oting
rosining92411423_rosin_ing
rotating92614553_rotating
rotting82919683_ro_tting
rounding102812283_rounding
rousting93913273_rousting
routing83821093_ro_uting
ruinating1039593_ruinating
ruining83514883_ruin_ing
sainting93215733_sainting
sardining1137573sardin_ing
splinting1238193splinting
sprinting12310033sprinting
squinting1936223squinting
stinting93415743_stinting
tainting93613583_tainting
tinting84620603__tinting
toiting83217093_toi_ting
training93015863train_ing
trining82919213tr_in_ing
trotting92510913tro_tting
trouncing1235153trouncing
truanting1035603truanting
unjointing1843963unjointing
urinating10310653ur_inating
variating13310953var_iating
warranting1444743warranting
wonting113214103_wo_nting
wringing13279623wr_inging
writing113713893wr_i_ting
wronging13327393wro_nging

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411846.81321817.3
3Display Results1841840.0762421.1
 (SQL Overall)1786911847.32524394.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.