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

52 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
poori7481623(None) 
poor65630221poor_
pooris83916841pooris
boor66130682boor_
boors74325012boors
door56928512door_
doors65022132doors
ephori1139602ephori
houri85915252houri
moor66628552moor_
moors74923142moors
moory105115792moory
nori47133142_nori
oorie53026362_oorie
padri85815172padri
peri65636972p_eri
poi57244662p_o_i
poo57757112poo__
pooch124815302pooch
pood75934322poo_d
poods85124752poods
pooed85226242pooed
poof95541662poo_f
poofs105222792poofs
poofy136213272poofy
pooh96027382poo_h
poohs103915712poohs
pool65835952poo_l
pools74427702pools
poon67341262poo_n
poons75430972poons
poop86532812poo_p
poops94422412poops
poorer82613992poorer
poorish123712302poorish
poorly1137892poorly
poos65949112poo_s
poove104514302poove
pore66451262p_ore
pork106929682p_ork
porn65636022p_orn
port66059632p_ort
pour611527472pour_
pours74623182pours
psoai7469922psoai
puri65931442p_uri
pylori1147162pylori
sori46039842_sori
spoor75016352spoor_
spoors84014032spoors
tori47542152_tori
zori137722922_zori

Search took 3 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 Filter178691538000.606294869.6
2DLD Change Limit53800521.92327977.1
3Display Results52520.0163250.0
 (SQL Overall)178691522.54570212.6
 
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.