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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
woomeras1313511(None) 
womeras1287591w_omeras
wommeras15133771wommeras
woomera12135771woomera_
boomers114115912boomer_s
roomers95416412roomer_s
womera11137592w_omera_
wommera14144062wommera_
wooers93712442woo_er_s
woofers133810582woofer_s
woolers104214022wooler_s
wormers124012572wormer_s
bloomers12348823bloomer_s
boogers104514633booger_s
bookers134016613booker_s
boomer104618513boomer__
boomerang1442973boomerang
boomerangs1552263boomerangs
boozers183912443boozer_s
cameras11313363_cameras
chimeras15388833chimeras
choleras13289043choleras
comers105328083_comer_s
cooers84324563coo_er_s
cookers134619463cooker_s
coolers93522493cooler_s
coopers114019483cooper_s
cooters94525723cooter_s
copperas14308573copperas
doozers17419293doozer_s
dormers104313923dormer_s
droseras935873droseras
foamers123812103foamer_s
footers104618333footer_s
formers128217953former_s
glomera1035943glomera_
gomeral1038833_gomeral
gomerals1147443_gomerals
gomers94116883_gomer_s
goobers10219623goober_s
groomers11388483groomer_s
homers114821973_homer_s
hoofers134513323hoofer_s
hookers144916513hooker_s
hoopers123616483hooper_s
hooters104520473hooter_s
hoovers134312703hoover_s
ionomers1038503ionomer_s
isomerase1144183isomerase
isomers9310043isomer_s
lookers114014073looker_s
loopers93914033looper_s
looters74419163looter_s
monomers12311033monomer_s
mooners94015343mooner_s
mooters93818623mooter_s
noosers74913923nooser_s
omegas936973__omegas
omers76923193__omer_s
operas8312453__operas
ormers84316143_ormer_s
podomeres1445723podomeres
poolers94217423pooler_s
roamers93713463roamer_s
roofers105013903roofer_s
roomer84718633roomer__
roosers74217873rooser_s
rooters74522933rooter_s
sooners73916643sooner_s
swooners11336863swooner_s
swoopers13317523swooper_s
toolers74416503tooler_s
tooters73818773tooter_s
vomers115614943_vomer_s
warmers124514293warmer_s
whoopers16286263whooper_s
wolfers13409633wolfer_s
wolvers13349313wolver_s
wonders113315993wonder_s
wonners104312813wonner_s
woodsias1244923woodsias
wooer84316693woo_er__
woofer124411363woofer__
woolens10398843woole_ns
wooler93615873wooler__
wooraris1145063wooraris
workers144612693worker_s
wormer114514913wormer__
wormgears1541923wormgears
wowsers13488763wowser_s

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 Filter1786911461620.420425454.8
2DLD Change Limit146162907.08020644.4
3Display Results90900.0303000.0
 (SQL Overall)178691907.53023730.5
 
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.