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

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

102 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
investments166590(None) 
investment1567101investment_
divestments17155162divestments
reinvestments1853102reinvestments
vestments1486812__vestments
arrestments1354693arrestments
disinvestments2063033disinvestments
divestment16146323divestment_
encystments1853623encystments
enlistments1345663enlistments
enmeshments1854363enmeshments
indictments1654403indictments
infestants1344503infest_ants
integuments1454563integuments
intendments1455703intendments
interments12716213inte_rments
internments13510283internments
reinvestment1753543reinvestment_
revetments1546433reve_tments
vestment13109203__vestment_
abetments1346074_abe_tments
adjustments2152864adjustments
advisements1754824advisements
anointments1355434anointments
arrestment1246254arrestment_
assessments1252934assessments
averments1449094_ave_rments
besetments1445294__besetments
blastments1444974_blastments
contentments1655484contentments
disinvestment1963474disinvestment_
ejectments2144054_ejectments
enactments1446524en_actments
encasements1547454encasements
encashments1875064encashments
encystment1754244encystment_
endearments14115384endearments
enlistment1246854enlistment_
enmeshment1755394enmeshment_
enserfments1654684enserfments
entreatments14114394entreatments
entrustments1453804entrustments
envelopments1953434envelopments
fleshments1843854_fleshments
governments1755424governments
ignescents1373384ignes_cents
impartments1745354impartments
impediments1874474impediments
impressments1853964impressments
incitements1556294incitements
increments14410104in_crements
indictment1545224indictment_
indorsements1565184indorsements
inducements1655534inducements
infestant1247234infest_ant_
infesters12237714infest_e_rs
ingestions1197594ingestion_s
injectants1943284inject_ants
inpatients1244294in_patients
insentient1049424insentient_
insistent948254insist_ent_
insolents9137524in__solents
instalments1354414instalments
instants8910154in__st_ants
instruments1354684instruments
integument1355804integument_
intendment1347174intendment_
intents72115704in___t_ents
interment11419224inte_rment_
internment12412254internment_
intestines10410254intest_ines
inurements1249144in_urements
inurnments1245934in_urnments
inveiglements1962414inveiglements
inventers12269534invent_e_rs
inventions1348314invention_s
inventress1343624inventre_ss
invents102812054inv____ents
inverters12239754invert_e_rs
invertins12911024invert_in_s
invested12229694invest_e__d
investigate15104304investigate
investigates16104214investigates
investing13119394invest_in_g
investors12227724invest__ors
invests10319684inves____ts
involvements2053374involvements
lineaments1245504lin_e_aments
movements1647514move__ments
nescients1145104_n_escients
ointments1166654oin___tments
overinvestments2372244overinvestments
pavements1647004pave__ments
ravelments1545194rave_lments
ravishments1954104ravishments
resentments1346544resentments
revealments1644494revealments
revelments1546864reve_lments
revetment1448324reve_tment_
testaments1265354__testaments
treatments1246284_treatments
vestmental1554034__vestmental

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.440406115.9
2DLD Change Limit1488191028.39017737.7
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.87620131.9
 
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.