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

105 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
poetising123871(None) 
poetizing2148681poetizing
appetising1544512appetising
monetising1346212monetising
mortising1238692mortising
peising103416762p_e_ising
poising103617102po__ising
precising14413272precising
premising14412412premising
prevising15510872prevising
amortising1345973amortising
appetizing2445403appetizing
azotising1945293azotising
baptising1446093baptising
betiding1239913_betiding
coediting1338333coediting
coexisting2044403coexisting
cognising1347043cognising
contusing1239143contusing
demising122012523_demising
devising133111523_devising
elegising1145423elegising
hogtieing1442863hogtieing
hoising113414413ho__ising
iodising1037563io_dising
ionising9310223io_nising
itemising1245883itemising
monetizing2247303monetizing
morticing1448013morticing
motiving1437163mo_tiving
noising83615173no__ising
noticing1139453no_ticing
novelising1444893novelising
obelising1256323obelising
outsing83320463_out_sing
palletising1453573palletising
patining11312303p_atining
pectizing2348013pectizing
peining104619153p_e_ining
pelletising1453393pelletising
peptizing2347113peptizing
periling11316863p_eriling
perishing1539533p_erishing
perusing11811063p_erusing
petering112516813p_etering
petting103720953p_et_ting
pettling1168213p_ettling
pleasing112611593ple_asing
plenishing1644693plenishing
poeticism1548333poeticism
poeticize2247523poeticize
poeticizing2545433poeticizing
poetise9314043poetis__e
poetised1138523poetis_ed
poetiser1037313poetis_er
poetisers1145303poetisers
poetises10313953poetis_es
polarising1347663polarising
polemizing2446913polemizing
policing13311673po_licing
polishing1536923po_lishing
porpoising1545833porpoising
portaging1346843portaging
portering122012303portering
porting103021783port__ing
portioning1347193portioning
posing93922643po___sing
positing11312303po_siting
postfixing2343243postfixing
posting105622243post__ing
postposing1555023postposing
posturing1238993posturing
pottering122612003pottering
potting103720893po_t_ting
poulticing1543403poulticing
pouting103519943pout__ing
practising1586363practising
praising113214563p_raising
prefiling1549533prefiling
prefiring1559073prefiring
prefixing2246783prefixing
prehiring1548383prehiring
premixing2157803premixing
prenticing1547883prenticing
prerinsing1347643prerinsing
presiding13510903presiding
pressing112516443pre_ssing
pretaping1439133pretaping
pretasting13239283pretasting
pretesting131810683pretesting
prettying1536043prettying
pretyping1764943pretyping
prewiring1547893prewiring
prising103321453p__rising
promising14410973promising
remising112516453_remising
rerising93017783_rerising
retieing92913713_retieing
retiling93319483_retiling
retiming113014193_retiming
retiring92717413_retiring
revising122714403_revising
seising84018863_se_ising
solecising1345753solecising
sortieing1046163sortieing

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.423422437.4
2DLD Change Limit1486411056.76321978.6
3Display Results1051050.0462282.6
 (SQL Overall)1786911057.23224708.4
 
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.